database - access: how to add a workorder to a customer -

i have noob question he, i'm learning :-)

i'm making form following tables 1 tblcustomers , 1 tblworkorders.

my question is:

when add customer new record, person stored in table: tblcustomers going fine.

the problem have table: tblworkorders, in table store technical information, sollutions , customers belongings. (adapter, notebook bag etc etc)

my problem excists when example customer named john doe comes problem 2 weeks later. in table tblworkorders should 2 records problems of john doe think has relationships between tables, can tell me find example or when it's short story, how this?

very difficult explain concept , start off scratch. prepared further research on different item. here place start: http://office.microsoft.com/en-us/access-help/guide-to-table-relationships-ha010120534.aspx

the following how use tables:

you need have common field in both tables (it can more 1 field, let's keep simple). easy way have customerid field data type field set to: autonumber (it says.).

tblworkorders have same field (doesn't have same name, let's keep simple) but, data type is: number field size: long interger.

if you're able use: database tools | relationships, , join 2 tables field, developing forms , reports lot easier.

your form based on tblcustomers table (i know, let's keep simple.) , sub form use tblworkorders table , 'link master fields' , 'link child fields' use customerid each table.