Need Data Entry Advice

[Mortie]

Pretty sure this is going to be a Beginner's Question, but it is driving me crazy.

Is there a process, using Action Scripting, for getting a parent/child link common field into the child table?

My primary table contains a Contact_Id field and a variety of child tables are linked with this same titled/length field in the child tables.

I have been using lookup tables for the most part but now, I have a browse in a child link where that doesn't seem to be practical. I can use this process but am now curious if there is a more practical method I can incorporate using Action Scripting.

Thanks in advance

[Al Buchholz]

or use a set to enter data and have the linkage automagically filled in.

[Mortie]

Thanks Al.

I must be doing something wrong in setting up my sets because they do not automatically fill. And I did think they automatically filled but not happening.

The attached images are my typical setup (sorry for landscape look but only way I can capture the screen).

[Al Buchholz]

I'm wondering if you are expected the contact information (name,address,something else) to be duplicated in the child tables even though the linkage from the child to the parent works.

Can you show the fields from each table that you expect to fill from parent to child?

[johnkoh]

Bod,

Did you know you can make smaller the " Set Editor"

[Mortie]

I'm wondering if you are expected the contact information (name,address,something else) to be duplicated in the child tables even though the linkage from the child to the parent works.

Can you show the fields from each table that you expect to fill from parent to child?

Al, the only field I am trying to fill is the child table Contact_ID. I am only trying to tie the child table to the parent table for relating info on a form.

To coin an old phrase, "son of a biscuit eater". I just tested with the change of enforcing referential integrity and it seems to work. I was not enforcing based on earlier advice on a different question.

[Mortie]

Bod,

Did you know you can make smaller the " Set Editor"

Thanks John

No, I was not aware of that. Good advice for future image sharing.

[Al Buchholz]

Bob

Your contactid should be entered without referential integrity.

Remove the referential integrity and duplicate the set to a new name with all the objects of the set.

Then drop the original set from the database.

Duplicating is magic at resolving internal issues of sets and tables with field rules.

Referential integrity should be avoided due to it's high cost vs benefit.

[Mortie]

Will give it a try Al

Is the high cost speed?

[Al Buchholz]

Will give it a try Al

Is the high cost speed?

Not so much speed as multi user locking conflicts and a 256 limit on the number of child records for each parent.