| Author |
Selection table update
|
|
| Jay LaViolette 2006-02-09, 8:28 pm |
| I am using a selection table made up of data from a number of tables to
populate cascading combo boxes. When I add new data to the tables I
want the selection table to update. I am having trouble because the
table is locked by the form with the cascading combo boxes.
This is in a multi-user setting with a split front end and back end.
What is the best method for doing this.
Please advise.
Thanks.
| |
| Rick B 2006-02-10, 9:24 am |
| What is a "selection table"?
--
Rick B
"Jay LaViolette" < johnlaviolette@yahoo
.com> wrote in message
news:1139515286.627538.190160@g44g2000cwa.googlegroups.com...
>I am using a selection table made up of data from a number of tables to
> populate cascading combo boxes. When I add new data to the tables I
> want the selection table to update. I am having trouble because the
> table is locked by the form with the cascading combo boxes.
>
> This is in a multi-user setting with a split front end and back end.
>
> What is the best method for doing this.
>
> Please advise.
>
> Thanks.
>
| |
| Larry Linson 2006-02-11, 3:24 am |
|
"Jay LaViolette" < johnlaviolette@yahoo
.com> wrote in message
news:1139515286.627538.190160@g44g2000cwa.googlegroups.com...
>I am using a selection table made up of data from a number of tables to
> populate cascading combo boxes. When I add new data to the tables I
> want the selection table to update. I am having trouble because the
> table is locked by the form with the cascading combo boxes.
>
> This is in a multi-user setting with a split front end and back end.
>
> What is the best method for doing this.
If I want the user to be able to select a particular record, I create a
Query to use as Row Source for the Combo that shows each distinct
identifying item of information.
Larry Linson
Microsoft Access MVP
| |
| Jay LaViolette 2006-02-12, 8:24 pm |
| Sorry, by selection table, I mean a table that populates the cascading
combo boxes.
e.g.
Col A, Col B from Table A Col A, Col B from table b
Rum 1 Pina Colada 1
Rum 1 Punch 1
Vodka 2 Collins 2
Vodka 2 Tonic 2
My problem is I am using a maketable query to combine tables like in A
and B. When a new value is added the maketable query is run. I can't
run the maketable query when the form is open as it locks the
"selection table'. Not a problem with one user, I close the form, but
when more than one user has the table open...
any suggestions?? Thanks for your time.
|
|
|
|