Where are my records?

S

Sheryl

I set security for my database after I had entered 4 complete records to test
my queries and reports. Now I can't see my relationships, I don't get the
new records showing up with my queries. What should I be looking for? I am
the owner with full permissions too. Do I need to redo something to make
them appear?
 
S

Sheryl

Joseph,

I've done some research with my database. For some reason one of my tables
aren't connected to my main table anymore. I have it joined by the main
PkgNo which I use to track all my records. Not joined by primaryIt worked
with the 1st four I used for testing, but now it won't read the new ones.
Anymore suggestions?
Thanks for responding so quick. All your guys are great.
 
S

Sheryl

I have 2 tables, 'tblPackageInfo' and 'tblDraftingQuality. [PkgNo] is what
joins everything. [PkgNo] is text and the same in both tables. I enter my
information in a form, 'frmEnterNewPkg' which is from the 'tblPackageInfo'.
I have a form, 'frmFindaPkgNo' which is based from a query that pulls
information from 'tblPackageInfo' that I don't want anyone to be able to
edit. I have a subform, 'frmSeniorEntry' that other people enter for fields
in the 'tblDraftingQuality'. I have 'frmFindaPkgNo' that also has the
subform 'frmSeniorEntry in it. Other people open 'frmSeniorEntry' and both
should be there 'frmFindaPkgNo plue 'frmSeniorEntry'. The 'frmSeniorEntry
won't show up in the 'frmFindaPkgNo' unless I actually go in to the
'frmSeniorEntry' and enter something.
[PkgNo] is the Primary in 'tblPackageInfo' and [PkgNo] in the Primary key in
the 'tblDraftingQuality'. I have tried different join types, etc.
Do I need to change the table relationships or change the set up of the
forms? I'm thinking that I should just take everything from the
'tblDraftingQuality' and put it in the 'tblPackageInfo' table. I don't think
that would be a good set up though. Really appreciate your input. Thanks.
 
Top