Relationship issue on my form

[BigMac4]

Hi all i might be being silly here but something is not working the way it did before, i have a table "sample" and a second table "recipe" i created a relationship between "sample - code" and "recipe - Description" when i created a form based on "sample" it did at one point return in the "description" field the data from the "recipe" table when i entered the "code" but now it doesn't. I cant see what i have changed to stop this from working.



Any ideas would be most helpful.

Mac

[A S MANN]

Explain the a relationship between "sample - code" and "recipe - Description". Is This One-Many type.If Yes than you can create a form with raw source sample and subform of recipe. Use Master Child relationship in subform
Is above info is suitable to you?

[BigMac4]

I have many samples with the same description so yes a one to many. I have a form already created using the Sample table just need one box with the description to be returned when i enter the Sample code. i am unsure what is ment by Master Child Relationship.

Cheers

Mac

[orange]

Here is an article that should help with basic concepts and relationships. You can search for parent if you want just that specific point.

http://www.databasedev.co.uk/databas...uirements.html

[BigMac4]

Ha solved it! Thanks for your help guys had the relationship set up wrong must have changed it by accident.

Cheers again

Mac