Form button to generate a record in a separate table..

[Jasontm01]

I have a database that currently has 2 tables for data and 2 forms for entering that data.

tblWork holds the majority of the information about anything we have going on for someone. tblSales is used to store information based on "sales."

All the information in tblSales also exists in tblWork but we wanted a separate way to track those records (tblSales does not have all the fields tblWork has)

I currently use two separate forms to enter the data and I would like to do this differently. Can I create a button on the main tblWork form that would automatically create a record in tblSales with specific fields?

For instance: on frmWork I have FirstName, LastName, PhoneNumber and OrderNumber fields that will be entered but I would like a button to generate a record in tblSales with those fields populated for me.

Thanks!

 

[Pat Hartman]

There is no reason to duplicate the data. Just use a query to select what you want from tblWork and get rid of tblSales entirely.

 

[Jasontm01]

Hmm, I guess I could do it that way. The only way I can is by having a query that looks at the "order number" field and if its populated the query shows it. That field is the only way to tell if a particular record was sold or not.

 

[Jasontm01]

Ok, I went ahead and changed it to use a query based on the tblWork and "Order Number" not being empty. It seems to work and saves the users some duplicate data entry. (not really sure why it was designed that way in the first place)