Access 2003 combo lookup

[martin]

Can anyone please help.
I have a main membership form/table that has a subform with function table
linked. This is obviously a fixed solution but I would like to make it more
dynamic with a combo box to create a new sub linked table or select an
existing one. The tables will all be identical and could probably be
created from a template. I have a bit of coding experience but have no idea
how to start or do it.

[Steve Jorgensen]

Well, you've written your question to make sense only if we already knew what
you're talking about. As soon as you start talking about multiple tables with
identical structure, though, I see a normalization issue.

When you have multiple sets of data with the same columns, they should be in
the same table, not different tables. There should be an additional field
that identifes the group, so you can distinguish one group from another.

On Sat, 7 May 2005 18:34:13 +1200, "martin" <de******@xtra.co.nz> wrote:

Can anyone please help.
I have a main membership form/table that has a subform with function table
linked. This is obviously a fixed solution but I would like to make it more
dynamic with a combo box to create a new sub linked table or select an
existing one. The tables will all be identical and could probably be
created from a template. I have a bit of coding experience but have no idea
how to start or do it.

[martin]

When I say membership I mean club membership form that has a sub form
with the club functions. I added this one club functions sub form /
table but want to add a combo selector to add new club functions or
existing ones. if you could just expand a bit on the normalization and
the grouping how it's done

bugs - undocumented features?

*** Sent via Developersdex http://www.developersdex.com ***

[Mike MacSween]

As Steve says your post is a little unclear. By 'function' do you mean like
a VBA function or a function of the club?

Steve is right to point out that if you are creating identical tables
something is almost certainly amis in the basic structure of the database. A
large proportion of questions in database newsgroups _appear_ to be to do
with code/forms or something (by which I mean that's what the poster thinks
is the problem), but are actually just examples of poor database design.

Books to read:

Database Design for Mere Mortals, Hernandez
An Introduction To Database Systesms, Chris Date
Designing Relational Database Systems, Rebecaa Riordan

Google for:

Relational Database Design
database normalization
Chris Date
EF Codd

These look OK, though you'll find plenty of good sites with the first 2
searches

http://www.15seconds.com/issue/020522.htm
http://www.geekgirls.com/databases_from_scratch_1.htm

http://www.dbdebunk.com/index.html if you like strong opinions (I think he's
usually right)

I'd stop doing anything in Access or any other database development
environment until you've got a grasp of the basic theory. I wasted a lot of
time trying to code my way around faulty database design.

HTH, Mike
"martin" <de******@xtra.co.nz> wrote in message
news:Gj*******************@news.xtra.co.nz...

Can anyone please help.
I have a main membership form/table that has a subform with function table
linked. This is obviously a fixed solution but I would like to make it
more dynamic with a combo box to create a new sub linked table or select
an existing one. The tables will all be identical and could probably be
created from a template. I have a bit of coding experience but have no
idea how to start or do it.

[martin]

Thanks Mike and you're right it's the db design that's the problem as I'm
not a db programmer but do embedded work. I just figured out from the
postings that I should just add anonther field to the linked table and
filter out with the sql query which specific club function I want to work
with. I have recently bought the Access 2003-professional results and
Access 2003 power programming with VBA that I have learnt the little bit I
know about db's

Thanks

Can anyone please help.
I have a main membership form/table that has a subform with function table
linked. This is obviously a fixed solution but I would like to make it
more dynamic with a combo box to create a new sub linked table or select
an existing one. The tables will all be identical and could probably be
created from a template. I have a bit of coding experience but have no
idea how to start or do it.