Re: Linking 4 child tables to 1 Parent table

There are situations in which keeping 1-1 "child" tables makes more sense.
It sounds like your situation may be one of these. Keeping those as
separate tables will probably be OK.

I'm not clear which queries you are referring to, but I do know that you can
build queries spanning 1-m table relationships and have them not be
updateable. Access HELP has more information about updateable queries...

Regards

Jeff Boyce
Microsoft Office/Access MVP


"larpup" <larpup@xxxxxxxxx> wrote in message
news:1144963013.179918.238150@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Jeff,

Thanks for responding.

The reason the 3 tables are related is because the child table may or
may not have data entered into them (and there are several fields). The
ratio is about 50/50..

I've separated out the memo fields into a table as I've experience
corruption in the past and if there is corruption, they've only lost
the comments. Many records do not have comments.

I have a payable table with quite a few fields that again, may or may
not be populated.

I have another table that is a one-to-many (Parent/Child). This
obviously must remain separate.

Re: your last statement, this I am aware of.

So is it best to include the separated tables into my main table?
Lastly, I still need to link several child tables to the parent and
right now they are linked to the key field of the parent, so some
queries are not updateable.

Any advice will be greatly appreciated.

Lar



.

Relevant Pages

  • Re: Connecting to the Same Table Twice
    ... RelationshipID (primary key) ... RelationshipName (parent, guardian, authorized pick-up, emergency contact, ... you might put spouse names into a separate table linked to this table). ... for each link between a child record and a caregiver record, ...
    (microsoft.public.access.gettingstarted)
  • Re: Linking 4 child tables to 1 Parent table
    ... The reason the 3 tables are related is because the child table may or ... corruption in the past and if there is corruption, ... obviously must remain separate. ... right now they are linked to the key field of the parent, ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Connecting to the Same Table Twice
    ... > RelationshipID (primary key) ... > RelationshipName (parent, guardian, authorized pick-up, emergency contact, ... > you might put spouse names into a separate table linked to this table). ... > for each link between a child record and a caregiver record, ...
    (microsoft.public.access.gettingstarted)
  • Re: Texas screwed up
    ... It's not OK to separate hundreds of children from their mothers ... because the children are being brain washed and might violate the law ... If I was to pick up my phone, call the police in your town and tell them you were having sex with your 13 year old child and they came and took that child away from you based on nothing but my phone call, wouldn't you be a bit peeved? ...
    (soc.retirement)
  • Re: UK - FATHER CANCELS CONTACT REGULARLY AT SHORT NOTICE
    ... Okay Martin - we were separated before she was born, ... agreed not to be present and the child is taken to his mothers and ... I dont even have an emergency phone number for him. ... separate issues and are not considered together in any way shape or ...
    (uk.legal)