Where are my records?

[Guest]

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?

 

[Joseph Meehan]

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?

You should not need to do anything. If you did the security correctly
and you are logged in correctly you should not notice any difference because
of the security. I am guessing you are using User level security.

Take a look at the tables and see if they still have the data. If so
just go one step at a time to see what has happened to it.

 

[Guest]

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.

 

[Joseph Meehan]

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.

I am not sure what you are explaining "Not joined by primaryIt worked
with the 1st four I used for testing"

Guessing that your re-established the relationship and it worked. Now
new entries are not working. Tell us how you are entering the new data? Are
you adding it in a table, query or form? Is that join field (PkgNo?) the
same format (single, double, text etc) in both tables? Do you have exact
matches in both tables?

 

[Guest]

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.

 

[Joseph Meehan]

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.

I still don't have a good idea what is going on, so let's go down
another level.

Let's look at table design. You have 2? tables. Why? Do you have 2
tables to better normalize the data or are you dividing the data into two
tables for some other reason? (Normalize means to reduce the amount of
duplicated data in a table.)