tables and fields

[questionit]

Hi

Its a question regarding creating and linking tables. I am using FileMaker Pro to implement it, but probably someone can help me here with the tables and fields making ?

I have following tables and fields:

Invoice: invoiceNo, company, total, paid, balance.
item : invoiceNo, itemName, quantity, price

Please advice if the categorization is correct or wrong?
I have made invoiceNo as primary key in each table and i have linked these tables with this key.

I have created a form and added Edit boxes with these fields on it. The problem is that i am able to write on only fields which are in table 'Invoice' - but i cant write on fields that are in table 'item'.

Where have i gone wrong.

Please help
thanks
Qi

[amitpatel66]

Hi

Its a question regarding creating and linking tables. I am using FileMaker Pro to implement it, but probably someone can help me here with the tables and fields making ?

I have following tables and fields:

Invoice: invoiceNo, company, total, paid, balance.
item : invoiceNo, itemName, quantity, price

Please advice if the categorization is correct or wrong?
I have made invoiceNo as primary key in each table and i have linked these tables with this key.

I have created a form and added Edit boxes with these fields on it. The problem is that i am able to write on only fields which are in table 'Invoice' - but i cant write on fields that are in table 'item'.

Where have i gone wrong.

Please help
thanks
Qi

As you said, you have made invoiceno as primary key in both the tables, you should have made invoiceno as foreign key in item table and not primary key. This should be your first change.