Jump to content

Value list to act like html


This topic is 6627 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I have a restaurant database with a value list (based on another database) for cuisines. On the web I use their codes (as opposed to their names) to avoid any overlap in the search between, say "Chinese/American" and "American."

So the way the database works is that you check the cuisine(s) in a field. I was wondering if anyone had any ideas as to how I could get another field to have the ID numbers from these cuisines in it (like the way that html checkboxes have a value that is shown to the user and a different value of the box itself), perhaps separated by a colon.

A looping script would be fine, I only need to get these values occasionally.

Thanks for any help you could offer...

Link to comment
Share on other sites

Your question is a bit vague but, I am going to try to answer your question by filling in some of the blanks with what I assume you are attempting to achieve.

It sounds like you are trying to display the ID of a cuisine that you checked off in a value list.


If I check off "American" in one field from a value list, It will display the ID # of "American" in another field...

The big trick here is you are taking a return delimited value list stored in a single field, and attempting to match this via a relationship to another table to then return a list of the related ID #s.

I believe you can at the very least try to make this work if you treat the field that stores the checked off cuisine(s) as a multi-key and use this field to be your related link to your cuisine table.

As for having some sort of field with delimited information returned to display the ID#'s, I suppose you could refer to some of the posts that have to do with returning a valuelist via a relationship in a calculation field... I'm a little fuzzy on this at the moment, but perhaps somone else can fill in the blank on this portion?

Link to comment
Share on other sites

This topic is 6627 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.