Hi Phucon,
Tables are never meant to be seen by the users. Showing tables is a hacker's dream and some users love to tinker with things they should not be allowed to even see. Showing data is what Forms and Reports are meant to do. That way you can use a combo box to show the text instead of the ID.
If you want to show the data so it looks like it does in a table you can use a Form in Datasheet view or use a SubForm. You can also use a List Box.
Kind Regards,
Patrick Wood
Gaining Access Technologies Founder
http://gainingaccess.net
Microsoft Access and SQL Azure Information Center for Developers
http://gainingaccess.net/SQLAzure/AccessAndSQLAzureInfo.aspx
--- In MS_Access_Professionals@yahoogroups.com, "saigonf7q5" <saigonf7q5@...> wrote:
>
> If the rowsource of a combo box has an id column and a description column, and when we use the wizard to create a combo box, it bounds to the id column automatically.
> Each time an item's selected, it stored the id in the table instead of the text (description). The users prefer to see the text in the table rather than an id. I satisfied user's request by changing the bound column from the id column to the description column.
> My question is, should the bound column always be the id column? Or it does not matter?
>
> Thank you
>
> Phucon
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (4) |
Tidak ada komentar:
Posting Komentar