Can't see form data

[slybitz]

*Please see my attached database.

So I'm trying to make a form and for some reason when I do the form wizard and enter all of the table fields to be shown in the form nothing shows up. A blank form just pops up. I can get the store number and bottler tables to make a form but nothing else. Are my tables messed up? Any help??

Thank you so much!!

-Sly

 

[ghudson]

The way you have it setup the tREI_Bottler_BottlerKey field and the tREI_StoreNumberID_BottlerKey must equal but the tREI_Bottler_BottlerKey is setup as an autonumber. You need to automate how those two fields aer autopopulated so that the fields contain the same number on new records. AutoNumber is not the way to do it. I do not use this type of method so I can not offer advice on how to do it or improve it.

 

[slybitz]

That makes some sense so I went ahead and fixed that (SEE ATTACHED PLEASE) but I still get the same problem. Any suggestions?

Thanks

 

[ghudson]

The SQL [record source] in the TEST34 form is now broken. You need to fix that first.

 

[slybitz]

Please ignore the forms that are already in there. Those were just OLD test forms. I'm trying to complete a whole new form. Sorry about that, I should have explained! Thanks

sly

 

[slybitz]

OK i figured it out. My tables were not set up correctly. Thanks for the help!

 

[lee_morgan]

What was wrong with your tables?? I have a similar problem