Relationship questions

[ertjeffrey]

Hey everyone, I am trying to make a database to manage my customers. Please don't advise CRM software unless
A - It is available off line
B - It is free

Here is the Tables I need to create
Contact Details Table
Work Order Details Table

Lets say for example I have customer "Jay" in contact details and I now want to add his first work order. Easy enough, right?

Now let's say I have ten work orders now for "Jay" and I want to just select "Jay" and see all ten work orders.

How do I do this?

[pbaldy]

One common way would be a form bound to the contacts table with a subform bound to the work orders table. Master/Child links would keep them in sync, so the subform would display the work orders for whatever contact was displayed.

[ertjeffrey]

Thanks, that actually sounds like it would work.

But how do I do this? Consider me a Access idiot

[pbaldy]

Did you sort this out? It should be fairly simple. Create a form for each table, then use the subform wizard to add the work orders form to the contacts form. It will ask about the linking field.