ASP using Access Tables with Lookup function.

[Pete Casey]

Hi,
Can anyone give me a pointer here. I have a site that is working well after
first build. All the tables in the Access database are standalone, if you
like, but I wanted to try and incorporate lookup columns within the database
to try and reduce possible input mistakes. The only problem now is one of
these columns is is used as a URL parameter on the site and It's not
bringing in the relevant info that corresponds to that entry, if that makes
any sense whatsoever.

If I change it back to not having looup columns it works fine, but I want to
crack this as it will mean less trouble in the future I suspect.
The column in question refers to a list of counties so I want the user to
pick that entry from a list, which of course refers to another table.

Any help here would be helpful.
Pete

[Manohar Kamath [MVP]]

Pete,

You could do that, and if the user has input invalid values, default to a
certain value. To save the database hits, you could somehow cache the valid
values in an array or even an XML string, and store it at application level.

--
Manohar Kamath
Editor, .netWire
www.dotnetwire.com
"Pete Casey" <oi****@blueyonder.co.uk> wrote in message
news:6c*****************@news-binary.blueyonder.co.uk...

Hi,
Can anyone give me a pointer here. I have a site that is working well after first build. All the tables in the Access database are standalone, if you
like, but I wanted to try and incorporate lookup columns within the database to try and reduce possible input mistakes. The only problem now is one of
these columns is is used as a URL parameter on the site and It's not
bringing in the relevant info that corresponds to that entry, if that makes any sense whatsoever.

If I change it back to not having looup columns it works fine, but I want to crack this as it will mean less trouble in the future I suspect.
The column in question refers to a list of counties so I want the user to
pick that entry from a list, which of course refers to another table.

Any help here would be helpful.
Pete

[Bob Barrows [MVP]]

Please do not multipost Pete. This is definitely a database-related question
so .asp.db was the perfect group in which to post it. Posting it here as
well did not increase your chances of getting an answer (most of us
subscribe to both groups). On the contrary, if somebody had taken his time
to answer it here, only to find that it was already resolved in the other
group, that person may have been annoyed enough to ignore any future posts
from you, thereby decreasing your chances of getting help in the future.

There are times when you will not be sure which group is most appropriate,
and you will want to post a question to both groups. In that situation, you
should use the cross-posting technique, rather than posting the same message
multiple times. To crosspost, put a semicolon-delimited* list of the
newsgroups to which you wish to post in the To: header of your post and post
it once. It, and any replies to it, will appear in all the newsgroups in
your list. So, if I reply in .asp.db, my reply will also appear here in
..asp.general.

* ... or whatever delimiter is recognized by your news client

Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Pete Casey]

Thanks I realised after I posted here that it was in the wrong group, hence
I then posted it into the db one.
Sorry and thanks.