Combining tables for data entry on a form

[wideasleep]

Hello,

I have a situation where I have been asked to combine two tables and make a form to continue to enter data. I have created a relationship between the tables and have gotten to creating the form but it doesn't allow me to add a new record. The "new record" selection at the bottom of the form is not selectable. I tried creating a add new record button but that was a no go also. Anyone have any suggestions?

Thanks

OS:Vista
Version:Access 2007

[Stang02GT]

How are these two tables related? is there some kind of ID feild that links them?

[wideasleep]

How are these two tables related? is there some kind of ID feild that links them?

I have a date field on both tables and another field called spills_injuries in both tables that are being used to link them

[Stang02GT]

I would look into joining them together in a query using and Inner or Outer joing depending on how you want to do it.

[wideasleep]

I would look into joining them together in a query using and Inner or Outer joing depending on how you want to do it.

I'll give that a try, Thanks