On 13/06/11 10:20, Richard Parsons wrote:
Chris Walkercdw_alug@the-walker-household.co.uk wrote:
Can you elaborate on "I want the tables to be created from the names in column 3"?
This isn't my data but imagine a list of pub names in Name1, a score in Number, Brewery Name in Name2, Yes/No in Y/N, a simple address in Where and random text in Notes.
So you want multiple tables, with each tables name being the Brewery Name?
That was my initial thought but I'm wading through the advice on the site you gave and now I'm far from sure that I'm doing things the right way at all.
Why not have one big table, with the Brewery Name as a column?
Give me a little while to digest the info on the web site, and I'll come back with some ideas, based on what I *think* I've learnt.