SQL statement in Forein Table field

R

redcat

Guest
Hello, I want to know if I can put a SQL statement to insert a result from another table.

ex :

I have a table BASE (id, base, adresse, clan) an another one MEMBRES (id, membre, date, base, adresse, clan ....) I was able to add a drop down for the field base in MEMBRES that get the list from the table BASES. But I also want to have the field adresse and clan get fill in from the BASES table depending on the choice of the base in the drop down and it doent work (I am not very good in sql)

Can it be done ?
If yes what would be the code to insert in Forein Table in the internal manager ?

Thanks to help :)
the adress of a working copy
http://membres.lycos.fr/chevaliersfr/data/membresfrancophones/index.php (admin.php)

~ redcat ~
 
E

Eugenio

Guest
redcat wrote:
>
> Hello, I want to know if I can put a SQL statement to insert
> a result from another table.
>
> ex :
>
> I have a table BASE (id, base, adresse, clan) an another one
> MEMBRES (id, membre, date, base, adresse, clan ....) I was
> able to add a drop down for the field base in MEMBRES that
> get the list from the table BASES. But I also want to have
> the field adresse and clan get fill in from the BASES table
> depending on the choice of the base in the drop down and it
> doent work (I am not very good in sql)
>
> Can it be done ?
> If yes what would be the code to insert in Forein Table in
> the internal manager ?

Hi,
at the moment it can't be done.

Eugenio.

(Latest version of DaDaBIK when this message was posted: 2.2.1)
 
Top