Form with 2 different control sources?

[RCurtin]

Hi,
I have just split up a table into tables so that has interfered with the form I had created for it. I have 2 main tables:

tblDrawingRegister:
DrawingNum
DrawingName

tblRevision:
Drawing num
Revision
LatestIssueDate
OrderNum

I split them up because there was alot of dublication. One drawing can have many different revisions. So I think it was better to split it up like this?

Anyways the form allows the user to add this information so some of the controls are bound to one form and the others to another. I know that I could do a query to combine the two tables but is that the best way to do it from an optimisation/ good database design point of view?

From a layout point of view I would prefer not to use a subform.

Thanks for your time,
RCurtin

 

[RCurtin]

Thanks very much for your reply. Thats exactly what I was looking for - I didn't know if using an SQL query to bring them together was the correct solution.

I will do that to tie the drawing and revision information together because I will need to use a subform to show transmittal information for each drawing (i.e. who sent them and the date they were received etc.)

Thanks a million,
RCurtin.