Access newbie looking for examples of databases - not so basic but not so advanced?

Hi All,

I've finally convinced my employer to get Access and I'm now in the process of converting my creaking Excel "databases" into Access.

It's been almost 20 years since I last looked at Access and while I've got the very basics, I'm struggling with the rest and can't seem to find what I'm looking for.

For example, I'm creating a customer order database. I've got the table and user form for the orders themselves, but to each one of these I need to add several jobs using a separate userform. If I remember rightly I need to use a query with links but I am having difficulty.

I have downloaded a couple of the examples from the Office website but to be honest it's a bit beyond me and also not really what I'm looking for.

As a stripped down example I have Table (Orders) with 5 fields - ID, customer name, order number, address and contact. This has an associated userform.
I also have another table (Jobs) with fields ID, customer name, order number, job type and cost.

What I want to be able to do (preferably not involving VBA but OK if need to) is to have a button on the Orders userform that will open the Jobs userform and allow the input of jobs related to that order (so that the customer name and job number feed through from the order form/table to the jobs form).

I hope that makes sense and my apologies if this seems "thick" but a basic example of the above will really help if anyone can assist.

I think that you need to set up a subform. Look at this tutorial and see if it leads you in the right direction.

http://www.datapigtechnologies.com/f...subforms1.html