If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You must register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Need Data Entry Advice

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.

Re: Need Data Entry Advice

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.