Access Relationship Help

decmatt · 25 Mar 2009 at 00:29

Hi

Here are my relationships
http://www.watotron.com/Geoz/upload/relationships.jpg

What I am trying to do is for the Client to have a catalogue of what he artists buys (Buying Habits), and the artists to have events that the client can go too. The client also makes enquirys of stock that he wishes to buy. If you have any questions on the ralationships please ask. But I just cannot get them to share data between each other and im quite stumped why. So any ideas from looking at it would be greatful!

Thanks

decmatt · 25 Mar 2009 at 02:51

I dont currently have any queries, I have tried imputting data via forms, I will use the enquiry bit as an example

When a customer makes an enquiry, the enquiry needs to be linked that that cutomer made the enquiry, so I have the linking table. But, the when I input it via the form, no record is inserted into the linking table, so it enters into enquiry, but not the linking.

decmatt · 25 Mar 2009 at 22:40

Any ideas? Just cannot get it to link data?

decmatt · 26 Mar 2009 at 00:16

Any ideas how I would go about creating this automation? I see I need to make a query, but how would I design the query to update when the user makes for example a specific enquiry?