I enter data everyday into a table for a loyalty program.

I want to create a relationship between two tables.

The relationship I want to create involves enterting data into one table and only when a check box is checked to be true do I want that particular record to go across into the other table.

How do I do this?

Are you looking to copy the data from table A to table B? This goes against the grain but can be required in certain circumstances (i.e. remove data to a holding table).

What is it you want to achieve?
Phil.