Relationship problems

[tflett]

I have a DB with 6 tables
tbl 1 (Person's Info)
ClientNum (PK)
FName
LName
+ all person info
tbl 2 (Employment info)
EmpID (PK)
ClientNum
EmpCodeNum
EmpStatus
TrainingRelated
StartDate
EndDate
tbl 3 (Employer Codes)
EmpCodeNum (PK)
EmployerName
tbl 4 (Trades)
TradeNum (PK)
TradeName
tbl 5 (Pri-Training)
PriTraID (PK)
ClientNum
TradeNum
tbl 6 (Sec-Training)
SecTraID (PK)
ClientNum
TradeNum

The problem i'm have is that when i go to create a form to enter all the
clients data
the details part of the form doesn't show in design view. And I also get
control source errors. If any can help me solve this prob That will be
great. The relationships are all one-to-many except for employercodes to
employment (1-to-1).
Tbl1 to tbl2 is 1-to-many, tbl1 to tbl5 and 6 is 1-to-many, tbl4 to tble5
and 6 is 1-to-many.

 

[tflett]

I need help on this problem ASAP!!

 

[scubadiver]

Is there any reason why "Employment" and "Employer codes" have to be in
different tables even though they are a 1-to-1 relationship? It would be more
sensible to have it all in the same table.

If you open a blank form in design view do you get the "details" section?

 

[mray29]

Are you using subforms for each of the many tables in your main form?

 

[John W. Vinson]

I need help on this problem ASAP!!

I'm sorry that the response (under 45 minutes) does not meet your
requirements. Let me know your address and I'll refund your fee for contacting
the newsgroup, together with my month's salary for answering.

On second thought, don't bother with the address... both sums are zero so
there's nothing to send.

John W. Vinson [MVP]

 

[John W. Vinson]

I have a DB with 6 tables
tbl 1 (Person's Info)
ClientNum (PK)
FName
LName
+ all person info
tbl 2 (Employment info)
EmpID (PK)
ClientNum
EmpCodeNum
EmpStatus
TrainingRelated
StartDate
EndDate
tbl 3 (Employer Codes)
EmpCodeNum (PK)
EmployerName
tbl 4 (Trades)
TradeNum (PK)
TradeName
tbl 5 (Pri-Training)
PriTraID (PK)
ClientNum
TradeNum
tbl 6 (Sec-Training)
SecTraID (PK)
ClientNum
TradeNum

The problem i'm have is that when i go to create a form to enter all the
clients data
the details part of the form doesn't show in design view. And I also get
control source errors. If any can help me solve this prob That will be
great. The relationships are all one-to-many except for employercodes to
employment (1-to-1).
Tbl1 to tbl2 is 1-to-many, tbl1 to tbl5 and 6 is 1-to-many, tbl4 to tble5
and 6 is 1-to-many.

Then use a Form based on tbl1; three subforms based on tbl2, tbl5 and tbl6;
and two separate maintenance forms based on tbl3 and tbl4. Meaningful
tablenames would be a good idea.

If you're trying to create One Grand Master Query to update everything -
don't, it won't work and it's not the right approach anyway.

John W. Vinson [MVP]

 

[tflett]

yes

Is there any reason why "Employment" and "Employer codes" have to be in
different tables even though they are a 1-to-1 relationship? It would be more
sensible to have it all in the same table.

If you open a blank form in design view do you get the "details" section?