By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,647 Members | 1,444 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,647 IT Pros & Developers. It's quick & easy.

Access 2003 combo lookup

P: n/a
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.
Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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.


Nov 13 '05 #2

P: n/a
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 ***
Nov 13 '05 #3

P: n/a
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.

Nov 13 '05 #4

P: n/a
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.

Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.