G
Guest
I have 3 tables, one for internal bookings, one for external bookings, and
one for the transport.
the transport is the focus here, and I need the other tables to export their
data into the transport table if the checkbox "boolNeedsTransport" is ticked
on the int' and ex booking tables. Once in the transport table, I can make
the transport bookings as normal, but the data in all 3 tables is very
different.
what is the best why of going about this? is it better to have the tables
separate and use another table in transport as a filter. Or to have a query
to pull the data when changed (this is a constantly moving database, and i
need it to update frequently).
any help would be greatly appreciated.
one for the transport.
the transport is the focus here, and I need the other tables to export their
data into the transport table if the checkbox "boolNeedsTransport" is ticked
on the int' and ex booking tables. Once in the transport table, I can make
the transport bookings as normal, but the data in all 3 tables is very
different.
what is the best why of going about this? is it better to have the tables
separate and use another table in transport as a filter. Or to have a query
to pull the data when changed (this is a constantly moving database, and i
need it to update frequently).
any help would be greatly appreciated.