"Melinda" wrote in message
...
I am getting set up accordingly, but have one slight problem. When I link
the tblticketno to the tblticketdetails I get a 1:1 relationship instead
of a
1:M relationship.

Probably with all your troubleshooting, you had set the recTicketNo field in
the tblticketdetails to be unique. That will cause Access to think it's a
1:1 relationship.

I am having trouble linking the recTicketNo being that
it is a autonumber in the tblTicketNo and just a number in the
tblTicketDetails.

Yes it should be a number, of size 'Long Integer'

I was thinking last evening that possibly I want to
change my PK in the tblticketno to the Invoice No. and have that relate
the
ticket and details table. Thanks so much for all your help.

Now you're on to something. That is likely what you want to do. An Invoice
No is likely unique and so is a good candidate for the PK in tblticketno.
Get rid of recTicketNo in tblticketno and in tblticketdetails. Make
InvoiceNo the PK in tblticketno and add InvoiceNo as a field in
tblticketdetails (make sure it's of the same data type/size; establish the
relationship between these two tables using that field.

You would find the resources at
http://home.bendbroadband.com/conrad...abaseDesign101 a
worthwhile read.

--
Joan Wild
Microsoft Access MVP