HELP!!! end of recordset (2)

[administrator]

I posted yesterday that I was having trouble with "end of
recordset". I decided to create a new form that has my
TBL Tickets and TBL Discounts together with TBL Discounts
controls on a tab control. Once again, when I try to go
to a new form, I'm still getting a "end of recordset".
I'm getting very frustrated. I've tried having a one to
one and a one to many relationship between these two forms.
It seems no matter what I'm changing, I can't enter data
from the forms only from the tables.

If I can't use forms to enter data, then I have to have
the user use the tables and that would be a disaster.

 

[administrator]

-----Original Message-----

Consider the following:

Did you condsider setting up a subdata sheet linking the
two tables through the ID. (Child and Parent?) Do you have
referential integrity setup with your relationships? Did
you create a query that combines the two for your data
input?


What I've done since my last post is set up a new form

that does use a query based on both tables. The TBL
Tickets.id from the FRM Discounts reads from the FRM
Tickets so the ID number is automatic if FRM Tickets is
open. The TBL Discounts.id is automatic reading from the
TBL Tickets.id so the number is exactly the same for both
id's. However, now the message I'm getting is 'can't find
record in the TBL Tickets with key matching field TBL
Discount.id'. I have checked and for example, if I have
FRM tickets open with TBL Tickets.id "55", on [FRM
Discounts]![TBL Tickets]![id] is reading "55" and so is
[FRM Discounts]![TBL Discounts]![id]. I've gone to my
table TBL Tickets and have a id "55". What I'm wondering
is if there must be a "55" in TBL Discounts? I do have in
my relationship "cascade update related fields".

By the by,

1. I have created a query uniting both tables.
2. Yes, I have refrential integrity set up on both tables
3. I would rather not use a sub data sheet because the
discount form is really big by itself. I don't think it
would be readable. I did try, however, to set up a tab
control and that didn't work.

Any help would be much appreciated. I've been trying to
correct this problem for about 4 days and I'm getting
extremely frustrated.