Two Forms

[statistics]

I have created two forms, one to enter patient information and another to enter oxygen fills. I have a one-to-many relationship between the two tables of patient information and oxygen fills. How can I restrict the user from inputting an account number into the oxygen fills form, that does not have that same account number in the patient information table?
Thanks to those that help!
stats

 

[Mile-O]

Why to forms for a one to many relationship? Put a subform on your form and link the fields there.

 

[statistics]

Since the patient maybe continuous over a period of time, I look at this as a time saving feature. Once the patients information is provided, then I only have to go back to the oxygen fills form and relate to the account number to fill out the patients oxygen fills for that day?
I do not want an account number in the table oxygen fills and not that same account number in the patient information table, because then there may be a possibility of a number of oxygen fills that do not correspond to a patient!

stats

 

[Mile-O]

Your patients info as the main form and a subform with the patients form for the oxygen is still the recommended practice.