for repeating data

[fleury]

Hi all!!
I encounter a problem here. My component table will link to the transaction table as one component maybe have more than one transactions. When I key in the component name, I want to display the output like simplified version below:

ID ComponentName DateTransaction
1 resistor 2/5/2011
2 capacitor 3/5/2011
3 transistor 3/5/2011
4 resistor 5/5/2011

So, how can I set the ID to be 1 for resistor? I wish to have the same ID for components which are having the same name.
My ID is autonumber type and componentName is test type.

Thanks for guidance.

 

[Trevor G]

Your question isn't clear, but if you have an ID field as AutoNumber you can't have a relationship to a text Field. You can create a relationship to a Number Field

 

[fleury]

attached is my file.
Please have a look and you can correct me if anything i have done wrong.

Thanks lots!!

 

[Trevor G]

You had no relationships in the relationship window, I added the relationships and attached is your sample. Look at the relationships window you now have a 1 to Many relationship for the 2 tables.

 

[fleury]

but can i make all partNo named apple to be having partID=1? That means the third record has partID=1 too.
It is due to I want to calculate the current apple on hand after that by sum quantity.

Thanks very much!