AnsweredAssumed Answered

Advice needed

Question asked by SteveKeiser on Jul 9, 2015
Latest reply on Jul 9, 2015 by philmodjunk


Advice needed


A portion of my database keeps track of equipment rentals. There is an Equipment table and a Rental table that relate to each other in a one to many relationship. When a new Rental record is created, _EquipID_fk is selected in the Rental table which relates to _EquipID_pk in the Equipment table. Then a location is selected as _FacilityID_fk in the Rental table. This fires off a script which updates the location in the Equipment table. When various locations want to know where their equipment is located there are sometimes errors because the location specified in the Rental table and the Equipment table sometimes doesn't agree. I am tempted to fix this by changing the location field in the Equipment table to be a calculation of Last ( Rental::_FacilityID_fk ). The side of me that wants to fix things right is telling me that when a new record is created in the Rental table, the location selected should really be selecting the location in the Equipment table and then a lookup sets this location in the Rental table. Since I can't really see that far down the road as those of you who do this thing on a larger scale, I don't know if it is worth all the work to change things to work the way I probably should have set it up in the beginning. Any advice would be really appreciated.