Copying data in one table to another-how to?

[jjh]

Hi:
I am looking for some guidance in doing the following:
I have a tableO that contains a list of objects that have associated attributes, specifically a list of system_names (object) and the associated attributes (additional fields in the table) that include port_name, port_direction. Think of each one of the records as a template that will supply data to another table, called the Instance table (tableI). The concept is that the user can populate the template with various objects and associated ports, and direction.
The table cols are;
PK|FK|system_name|port_name|port_direction|

The data for this table is manually entered via an associated form.


At some later time, the user want to make a copy of an object(e.g. a record in tableO) by populating Table I (the instance table). The first few fields of tableI are named identical to tableO. Table I contains additional fields that further refine the template, by adding a object_property field, and a port_direction_property field.
Table I looks like:
PK|FK|system_name|port_name|port_direction|prop1|prop2

The forms interface allows the user to fill in the fields in the TableI (intance table) directly, or, lets the user scroll through the list of objects in the template table, and chose a template, copy the fields:system_name|port_name|port_direction into the same fields in table I, and then add values to prop1 and prop 2 manually.

I made the combo box control that will list the objects from the object column of the template table (table O) and make the desired selection. I have a radio button adjacent to the combo box that when clicked, will copy the selected record and designated fields from the template object table (tableO), into the same fields of the instance table (table I). The instance table is displayed on an adjacent form.

After the fields are copied to the instance table, the user can type in the data into the additional fields (e.g. prop_1, prop_2), and complete the record.

I do not know how I can do the 'copy' from tableO to table I when the radio button is pushed. I know to allow an action when the radiobutton is 'clicked'. Table O and tableI are not currently related.

Can you provide some guidance?
Thanks a lot for your time
J

 

[KjWhal]

Hi:
I am looking for some guidance in doing the following:
I have a tableO that contains a list of objects that have associated attributes, specifically a list of system_names (object) and the associated attributes (additional fields in the table) that include port_name, port_direction. Think of each one of the records as a template that will supply data to another table, called the Instance table (tableI). The concept is that the user can populate the template with various objects and associated ports, and direction.
The table cols are;
PK|FK|system_name|port_name|port_direction|

The data for this table is manually entered via an associated form.


At some later time, the user want to make a copy of an object(e.g. a record in tableO) by populating Table I (the instance table). The first few fields of tableI are named identical to tableO. Table I contains additional fields that further refine the template, by adding a object_property field, and a port_direction_property field.
Table I looks like:
PK|FK|system_name|port_name|port_direction|prop1|prop2

The forms interface allows the user to fill in the fields in the TableI (intance table) directly, or, lets the user scroll through the list of objects in the template table, and chose a template, copy the fields:system_name|port_name|port_direction into the same fields in table I, and then add values to prop1 and prop 2 manually.

I made the combo box control that will list the objects from the object column of the template table (table O) and make the desired selection. I have a radio button adjacent to the combo box that when clicked, will copy the selected record and designated fields from the template object table (tableO), into the same fields of the instance table (table I). The instance table is displayed on an adjacent form.

After the fields are copied to the instance table, the user can type in the data into the additional fields (e.g. prop_1, prop_2), and complete the record.

I do not know how I can do the 'copy' from tableO to table I when the radio button is pushed. I know to allow an action when the radiobutton is 'clicked'. Table O and tableI are not currently related.

Can you provide some guidance?
Thanks a lot for your time
J

To copy from one table to another write a query like this

INSERT INTO table I (system_name,port_name,port_direction)
SELECT system_name,port_name,port_direction
FROM table O
WHERE O.primaryKey = selectedItem.primaryKey

the last (WHERE) line being pseudo code.

Anyway with that particular query written you can just call it each time the user clicks the button and feed it a means of identifying the item the user selected. I'd be more specific but I didn't quite follow your explanation of your interface.