B
Brian4JC
AAARRGGHH! After 2 days of solid trouble shooting, this has become a real
mess. At the core is 3 tables - Personal Info, Tour Info, and Unit Info.
The form is pretty simple: The Personal Info is the main form with the Tour
Info as the subform. There is one field from Unit Info on the subform as
well as I need to connect the Tour with the Unit.
Each person can have muliple tours (Personal > Tour = One to Many on SSN)
and each unit has multiple people on tour (Unit > Tour = One to Many on Unit
ID). I need to be able to assign the individual to a Unit for each tour as
the person can work for mulitple units.
Any suggestions? If I pull the Unit data off the subform, it still doesn't
work (this makes the subform a single-table based sub). I've checked all the
security settings...when I attempt to add a record, it just gives me a system
ping and no error so I have no clue what might be going on in the background.
Thanks for your help in advance...
Brian
mess. At the core is 3 tables - Personal Info, Tour Info, and Unit Info.
The form is pretty simple: The Personal Info is the main form with the Tour
Info as the subform. There is one field from Unit Info on the subform as
well as I need to connect the Tour with the Unit.
Each person can have muliple tours (Personal > Tour = One to Many on SSN)
and each unit has multiple people on tour (Unit > Tour = One to Many on Unit
ID). I need to be able to assign the individual to a Unit for each tour as
the person can work for mulitple units.
Any suggestions? If I pull the Unit data off the subform, it still doesn't
work (this makes the subform a single-table based sub). I've checked all the
security settings...when I attempt to add a record, it just gives me a system
ping and no error so I have no clue what might be going on in the background.
Thanks for your help in advance...
Brian