Search results

Dave, not sure if this really addresses the problem. I've attached a screen-shot from the web of the Tariff matrix that I am trying to replicate in Access tables. Thanks. Chris

I am attempting to construct a database for the letting of holiday cottages and since I am relativley new to Access I would appreciate a pointer on how to proceed. I have two tables (attached jpeg), the first (tblCottageBands) contains records of each cottage with the price/wk for each price...

Thanks to all that replied, and you all spotted the deliberate error in my transcript of the tables as I had actually stored customerID and cottageID as suggested. (this is where a pic of the table relationships would be so much easier than describing in words) Len's suggestion looks quite sound...

Being a newbie I have a general table design question which I would be grateful if someone could advise upon. In Access 2000 I currently have 3 tables for use in a holiday cottage rental system: tblCustomer (customer details) name (text) address (text) telephone (text) etc..... customerID...