Copy contents of Field to new field in another Table

S

steve.perris

Joined
Jan 9, 2007
Messages
1
Reaction score
0
Hi - usual apologies from a humble beginner, particularly if I don't explain my problem very well.

Key Tables involved are MAIN and SECOND
Key Fields involved are
- MAIN_SalesOrder (happens to be the primary key) (yes, for a specific reason)
- SECOND_SalesOrder (alpha numeric field)

I have the data in MAIN setup to work with on FORM-M, and the data on SECOND using another called FORM-S.

I have assigned an OnClick event to the field MAIN_SalesOrder in FORM-M to MACRO1. MACRO1 opens FORM-S, creates a new record, populates a bunch of fields in the record using the SetValue command, and closes it down. All with the ECHO off so it is hidden.

BUT - what I don't know how to do is to get the contents of the field MAIN_SalesOrder set as the value for SECOND_SalesOrder, i.e. copied over into the new record.

Any help would be very much appreciated. Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update table field by content in another field in the same table 2
Appending records to new table using field names as values 2
How can I copy the ID field into another table in the same databas 2
Copy record into same table 1
Syncronizing data field from one table field to another table 1
combining two or more table fields into a single table field 1
Auto populating fields from another table 3
Calculated field in a table 6

Back
Top