I have the following setup:

A form,[Project] with multiple subforms, [Project Info], [Project Change Orders], etc. I want to be able to limit the number of "pages" available on some of the subforms but not all of them. That is to say, I would like to limit the user to enter only 1 record in [Project Info] for every record in [Project] but I want multiple records available in [Project Change Orders] for each record in [Project]

Any ideas how I can do this?

If Project Info can only be held once, shouldn't this be part of the Project table as it is not a one to many relationship?

Is there a reason as to why this data is being stored in a seperate table?

Cheers,
SteveA