Major Linked Forms Problems!

[SteveC24]

Hi,

I have a form "Fish Details", which contains a fish's name and photo etc. (sounds strange I know!). From that form, I want 2 linked forms, one to record purchases, and one to record deaths.

I cannot get my linked forms to work. Every time I set them up, it comes up with an error about how it cannot add/update the record as it needs a related record in table "fish" (my main form).

I have all my relationships sorted out, and used the wizard to create one linked form, and the button wizard to do the other.

PLEASE HELP!

Thanks,

 

[casey]

Sounds fishy!

1.) You could check the recordsource for each of your forms and make sure you've included the linked field.

2.)If you're sure that you've included the linked field in each form's recordsource, then check the joins between the tables (in the form's recordsource, not the relationships!) and make sure all the records that you intend to show up do so. If they aren't all there, then adjust the joins between the tables in the recordsource that's excluding your data. You could set it up to show all from one table to make sure that all are included.

I know this is a simple answer, but my experience is that when records don't show up when they should, it's often due to tables that are joined in a way that limits the results.

HTH

 

[SteveC24]

The problem isn't that fact that it doesn't show the right records, that I can sort later, my current problem is, it won't let me enter any to start with!!!

Thanks,

 

[Idjit]

Steve,

I've had this happen myself. The problem is that for every record in your secondary table, the ID number (or whatever variable links the 2 tables) must have a corresponding ID in the main table. You get that error message when the ID in your secondary table doesn't exist in the main table. As an example:

Say you have a customer table and an orders table which are linked by CustID (one-to-many). Every time you add an order to the orders table, the CustID must also exist in the customers table (you can't have an order without a valid customer to send it to).