G
Guest
I'm not sure how to title this, but the problem is straightforward enough - I
have a main project table (with an autonumber field as the primary key) and
several related tables that are linked together referencing that project
number. I have forms that I use to enter data in these related tables - they
had been sub-forms, but I had to break them out as they were getting too
large to be usable in a tabbed format. I've got the forms opening now using
command buttons, and they are only opening related records, as they should -
but when there are no related records (i.e. I haven't added an evaluation to
the project yet) the new record that it shows doesn't have the project number
populated. This is a major usability issue, and so I've got to get it working
fast - it's been suggested by a user that 'maybe you can have it make a new
record if there isn't one' but if there are records, we don't want blank ones
created. Any suggestions??
have a main project table (with an autonumber field as the primary key) and
several related tables that are linked together referencing that project
number. I have forms that I use to enter data in these related tables - they
had been sub-forms, but I had to break them out as they were getting too
large to be usable in a tabbed format. I've got the forms opening now using
command buttons, and they are only opening related records, as they should -
but when there are no related records (i.e. I haven't added an evaluation to
the project yet) the new record that it shows doesn't have the project number
populated. This is a major usability issue, and so I've got to get it working
fast - it's been suggested by a user that 'maybe you can have it make a new
record if there isn't one' but if there are records, we don't want blank ones
created. Any suggestions??