Form Populating

[Guest]

I created a form which joins together different tables in
a relational database for storage purposes. After putting
in a few records I had to bring in another table to the
form. After altering the query for the form, I lost the
original records that I entered. I looked in the tables
and the information was still there, but the records were
no longer displayed in the forms. Is there anything I can
do to bring these records back up or does the new query
for the form prevent this permanately?

 

[Alan Fisher]

-----Original Message-----
I created a form which joins together different tables in
a relational database for storage purposes. After putting
in a few records I had to bring in another table to the
form. After altering the query for the form, I lost the
original records that I entered. I looked in the tables
and the information was still there, but the records were
no longer displayed in the forms. Is there anything I can
do to bring these records back up or does the new query
for the form prevent this permanately?
.
Look at the relationship type between the tables. More

than likely you have it set to only show records where
data in both tables are equal. Set it to show all records
from the main table and only those from the new table that
match.

 

[Guest]

Thanks appreciate it, that's exactly what happened I
think. Gotta check in the morning. Thanks again.