Re: Linking 4 child tables to 1 Parent table

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: 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
    ... There are situations in which keeping 1-1 "child" tables makes more sense. ... separate tables will probably be OK. ... I'm not clear which queries you are referring to, but I do know that you can ... right now they are linked to the key field of the parent, ...
    (microsoft.public.access.tablesdbdesign)
  • Re: UNEXPECTED result on MontaVista Linux
    ... calling 'exit' in both the parent and the child will flush them twice. ... But the two processes then go their separate ways, ... the roads after a fork. ...
    (comp.os.linux.development.apps)
  • Unix Programming FAQ (v1.37)
    ... Why use _exit rather than exit in the child branch of a fork? ... Why doesn't my process get SIGHUP when its parent dies? ... How do I create a named pipe? ... How do I compare strings using regular expressions? ...
    (comp.unix.programmer)