Search results

  1. E

    Best practice on hotel room allocations

    Hi I'm building a DB to manage a seasonal booking system for a tour operator that runs some special events during the year at several hotels. The operator receives allocations of rooms for a given period (from date to date) including sometimes several different room types per hotel per event...
  2. E

    Changing Data Type Once DB populated

    Hi There I have a DB with several thousand records in a table representing SIM card information. One of the fields is a FK Customer field. It is based on a lookup from the Customer table however for some reason unbeknown to me the data type created was Text instead of Number, even though the...
  3. E

    SIM ID or Autonumber as PK

    Hi Can someone tell me if I am better off using an Autonumber as the PK in a table of SIM cards (GSM phone cards). Each SIM has a globally unique SIM ID number. It has a certain structure however from my perspective I don't care too much about the structure. I have a list of SIMs we have...
Back
Top Bottom