Data into a table

[wop0703]

I have a table that is linked to a form. The user can enter information in the form and it is saved in a table. I want to make another table that only pulls certain information from the table that is being updated by the form. This new table must be able to be updated as well.

Any suggestions?

 

[ScottGem]

I have a table that is linked to a form. The user can enter information in the form and it is saved in a table. I want to make another table that only pulls certain information from the table that is being updated by the form. This new table must be able to be updated as well.

Any suggestions?

You don't do this. One of the primary reasons for a relational database is to reduce or eliminate data redundancy. Therefore you would NOT have a second table. with the same info.

What you CAN do, is create a query that uses only certain fields and/or filters for only certain records. You can then use tha query as the Recordsource of another form.

If that doesn't help, please exaplain, in greater detail what you are trying to ultimately accomplish and we may be able to suggest other laternatives.

 

[Pat Hartman]

You need a query rather than a table that duplicates data. Open the query builder and select the source table. Thenselect each field you want. If you have any criteria put that in the criteria slots. Run the query to be sure it is selecting what you want. You can use the query as the RecordSource for forms and reports or to export from if that is what you are trying to do.

 

[wop0703]

The reason I wanted another table was that some information the user has inputted is used elsewhere and must show up in another form and the user will have to input more data depending on his selection in the first form feeding the first table.

 

[ScottGem]

That doesn't change the advice Pat and I gave you. If the additional data being entered is in the same table, then you still need to use a query and/or a different form. The point is you do NOT duplicate data. If the add'l info is in a separtate table then you use a subform to input it.