mavtech
Posts: 133
|
| Posted: 11/29/2004, 12:18 PM |
|
I am building a record builder grid.
I have it setup to have two separate connections.
It is adding records to a table called attend.
I pick a name from a drop-down list from another connection that connect to a table called contacts.
I can add this record but I also would like to get the field contact_id from contacts table but how do I do it as it is based on the drop down selection.
Paul
|
 |
 |
Damian Hupfeld
|
| Posted: 11/29/2004, 8:58 PM |
|
You use the BOUND column to point to contact_id and the TEXT column points
to the contact_name field.
regards
Damian Hupfeld
http://www.nexthost.com.au/services.php
|
|
|
|
mavtech
Posts: 133
|
| Posted: 12/01/2004, 8:06 AM |
|
When I submit or add this to the database I need the Contact Name and the contactID into the table from the dropdown I only get the bound column.
Paul
|
|
|
|
Don Safar
|
| Posted: 12/01/2004, 2:32 PM |
|
The bound column is all that is submitted with the form. You will need to
use dlookup to retrieve the contact name matching the contactID.
"mavtech" <mavtech@forum.codecharge> wrote in message
news:541adebee58857@news.codecharge.com...
> When I submit or add this to the database I need the Contact Name and the
> contactID into the table from the dropdown I only get the bound column.
>
> Paul
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
mavtech
Posts: 133
|
| Posted: 12/02/2004, 6:02 AM |
|
I have been trying this but I can't seem to get the right where condition.
Paul
|
|
|
|
Don Safar
|
| Posted: 12/02/2004, 10:40 AM |
|
Post your code here so we can look and help you determine what the problem
is.
"mavtech" <mavtech@forum.codecharge> wrote in message
news:541af208e0a5f3@news.codecharge.com...
>I have been trying this but I can't seem to get the right where condition.
>
> Paul
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
