Limiting to one form

kermit5

Registered User.
Local time
Today, 18:44
Joined
Nov 2, 2001
Messages
122
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
 

Users who are viewing this thread

Back
Top Bottom