Search results

Hi again, Im obviously more of a novice at access than i thought because i cant wrap my head round what sounds like a simple concept, so I'm hoping the amazing people here can help. I have a table called tblRates which stores Rate ID (Number, Primary Key), Rate Alias (Text) and Rate Amount...

ah thanks!

This works fantastically, many thanks! One last thing, is there any way to make it default to the first location for a specific Client ID? I was looking in the expression builder for default value, but I'm unsure how to make it pick the first of the 3.

Many thanks, I understand what I need to do. Would I have to make duplicate entries for each client depending on the locations I have? Im just thinking in terms of ease of use to add another client to the database

thanks for the reply. the locations are simply things like London, Birmingham, Guildford etc. which will obviously be shared by some clients. Does this affect how i make a location table?

do you mean simply a table that will serve as a lookup with a set of locations? each client has a set 3 locations that wont change. When data is captured, it is for a consultancy visit, so the client name will be selected, and 1 of the 3 locations needs to be a dropdown to select which location...

thats not too bad, theres no actual data in the database yet. how would the locations table look exactly?

Hi guys, Im hoping you can help me here. Im currently making a database with several tables for clients, consultants etc. On the data capture form, Im using a combo boxes for client name (which links up to the Client ID when I use the lookup wizard, but still produces the name), consultant name...