Connecting tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I register about 100 items on our costumers. This is split up in several
tables. In Lotus Approach I have connected these tables through CostumerID.
When I ad a new costumer the ID I select is automatically added (and deleted)
in all tables. This also works in FileMaker when I mark “allow/delete
creation of records in this table via this relationshipâ€. How can I create a
relationship in Access 2000 that take care of this function?
 
I register about 100 items on our costumers. This is split up in several
tables. In Lotus Approach I have connected these tables through CostumerID.
When I ad a new costumer the ID I select is automatically added (and deleted)
in all tables. This also works in FileMaker when I mark “allow/delete
creation of records in this table via this relationship”. How can I create a
relationship in Access 2000 that take care of this function?
Click to expand...

Lotus and Access ARE TWO DIFFERENT PROGRAMS. They require a different
approach and different mindset.

It is neither necessary nor appropriate to create empty "placeholder"
records in the related tables at the time that a customer record is
created. Instead, you can use a Form based on the customer table, and
Subforms based on the related tables. Use the CustomerID as the
master/child link field of the Subform controls. When you add data to
a child table using a subform (but not before), the ID will fill in
automatically; and the subform will automatically display any related
records when you bring up a customer's record on the mainform.

You should certainly have a Relationship defined, in the relationships
window; but (unlike Approach) this relationship only *constrains* what
you can add. You can't add a record to a child table unless it has a
matching main table field; but it doesn't automagically add an
unneeded record, and it needn't.

John W. Vinson[MVP]
 
Back
Top