1 table, 2 data entry forms?

[Guest]

I have an Event table that stores data for two different types of events:
Events and AfterEvents. Am inclined to develop two data entry forms because
fields for each are mutually exclusive with the exception of one - hosts
(both will use the same Hosts Lookup table, multiple hosts for one event
possible). An IsEvent flag and an IsAfterEvent flag on each respective form
will id records for query purposes (EventID, IsEvent) or (EventID,
IsAterEvent).

Will this work? Is there a better way? OK to use two forms to enter data
into one table?

Thanks,
Gin

 

[Al Campagna]

Gin,
No... two (or more forms) may address the same table. In something like a
manufacturing process, a user might fill in preliminary information (job setup), another
user can later update that record with new information (production info, or Quality
Control), etc etc throughout the complete process.
What's more important in answering this question is "do you really need two forms", or
are you trying to combine two separate processes into one. We would need to have you
describe what the Event info deals with vs the AfterEvent info in order to give a more
definitive response.

--
hth
Al Campagna
Candia Computer Consulting
Microsoft MVP - Candia, NH USA
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

 

[Guest]

Al,
you answered my question.
thank you.

Gin,
No... two (or more forms) may address the same table. In something like a
manufacturing process, a user might fill in preliminary information (job setup), another
user can later update that record with new information (production info, or Quality
Control), etc etc throughout the complete process.
What's more important in answering this question is "do you really need two forms", or
are you trying to combine two separate processes into one. We would need to have you
describe what the Event info deals with vs the AfterEvent info in order to give a more
definitive response.

--
hth
Al Campagna
Candia Computer Consulting
Microsoft MVP - Candia, NH USA
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."