Master form with auto-complete AND two details forms

Applications Forms
#1

Hi everyone ,

I am asking help because i didn’t find solutions yet. I’am working on a very particular master / detail form.

I’m using a simple master form and i would like to have kind of auto-complete search field for the ID, in the same page. Is it posible ?
Otherwise I got another question. I need to link two detail forms. A is master, B and C are the details. B and C are independant but I didn’t successed linking both of them to the master, is it posible ?
My last problem is : C need “JOIN” in the SQL statement but i can’t use a grid as detail. Is there any solution?

I am new here please apoligize my bad english. I didn’t find good sample of what I actually want. I am not really sure about my way of thinking for my application. If someone got any suggestion i will appreciate !

Best regards,
Pierre

#2

Ok guys,

I found a way to do what i actually want. The trick was to create view (in phpmyadmin)
MASTER : one table (simple form)

  • CHILD 1 : one table (simple form)
  • CHILD 2 : 3 tables (view)
    All are linked with the same ID (ID is the key in MASTER, and both of the CHILD got an ID field).
    I tried to use CHILD2 with grid, but it couldn’t work (can’t link IDs). So I decided to use CREATE VIEW in phpmyadmin. Smart SC found the view in my database and then i used this view as a simple form.

I am now looking for a trick to do the auto-complete search about my ID. Is there a way to use auto-complete on a form ? I know i can use it with grid (ie. video tutorial) but how to do it with form?
please someone help me :slight_smile:

Belle journ?e,
Pierre