Creating a linked subform for client profiles

[samjl6]

So I am a COMPLETE beginner on Access, so you will have to respond with extremely basic answers!

Basically, I have a client profile (made up of a form so that I can add new ones as they come in), and on each client's profile I have another form where I can see their orders/bookings. The client form uses a primary key in its table so that each new client is given a unique number. However, in the table for the orders/bookings, when I complete a new entry on the subform of a client's profile, I want it to appear in the table under the client's ID, but at the moment, it's just automatically labelling them 1, 2, 3, 4, etc. even though I've tried linking them through a relationship.

Can someone explain how I can do this? Hope I make sense!

[ranman256]

The tClient table will have ClientID (autoNum)

the tOrders table will have :
OrderID (autonum)
ClientID (long)

the 2 ClientID fields will be joined in the relationships.
this works every time.

[samjl6]

What should the relationship settings be? I've just tried adding an order ID and making that as the primary key rather than the client ID again and tried relating both Client IDs but now if I try fill in the subform it comes up saying "the LinkMasterFields property setting has produced this error: 'Expected: ='
I'm happy to post my database if you want to take a look?

[aytee111]

Ranman's explanation was very clear (to me). Post your db if you are still having issues.

Check your links from main form to subform, they should be set to ClientID.

No settings on the relationship, just a straight line linking the 2 ClientID fields, with Referential Integrity.

[samjl6]

I'm not sure what I was doing wrong but I remade it using a wizard and all seems to be fine now! Thank you for the help though!

[aytee111]

Glad it worked out! Mark this as solved, then.