Jackie has attended:
Access Introduction course
Access Intermediate course
Relationship created by Look Up wizard
I have created a Client table, a Contract table and an Invoice table.
In the Contract table, I have used the Look up wizard to create a relationship with the Client table to give me a list of current Client names from the Client table.
This appears to work OK until I look into the relationship, at which point I see that the wizard has created the relationship between Client ID in the Client table and not with Client Name in the Client table.
Although this doesn't effect this particular look up/relationship, it seems to be having a knock on effect further down the line when I try and create a look up in the Invoice table back to the Client table to again look for a Client Name. Instead of giving me the name, it is giving me the Client ID.
Why is it not linking Client Name in the Client table with Client Name in hte Contract table? Is this something to do with the Client ID being the primary key?
RE: Relationship created by Look Up wizard
Dear Jackie
Thank you for attending Access Courses. I hope you enjoyed them and benefited from them.
When you create a relationship between two tables either by lookup wizard or relationship window the one-to-many relationship is created between the Primary key and the Foreign key.
I would suggest you to pay particular attention when you are in the Lookup wizard. Please ensure that you choose the Customer name and NOT the Cust ID. That could be the main reason you are only viewing Customers ID instead of names in eth table.
However, if you are choosing the right field then we need to look at other possible reasons whey it might be doing what it
