Forums: Dropdown list - Forums

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

Dropdown list Rate Topic: -----

#1 User is offline   kleanthis 

  • Advanced Member
  • PipPipPip
  • Group: Members
  • Posts: 63
  • Joined: 23-April 09

Posted 23 September 2018 - 09:20 AM

I have two two tables. The fields in table one are (Id, Class, No)

ID..Class..No
1....A....1
2....A....2
3....A....0
4....B....1
5....B....2
6....B....0

On table two

ID...Name...Class...No
45....Marios.....A....2
46....Nick.........A....1
47....Marion.....B....1
48....Andrea....A....2
49....Goerge....B....1
50....Dino........B....2



I need to have dependent Dropdown list with the Names of the second table. The dropdown list basing on the values in the first table (Class and No). No problem until now. I use the Visual Editor - Lookup wizard.

THE PROBLEM
When i have in No = 0 I need to show the names of No 1 & 2.

example

Class A
No 1
It must show Names - Nick

Class A
No 2
It must show Names - Marios, Andrea

Class A
No 0
It must show Names - Nick, Marios, Andrea (that is my problem) Pls help.
0

#2 User is offline   Arkie 

  • Advanced Member
  • PipPipPip
  • Group: Members
  • Posts: 77
  • Joined: 19-October 15

Posted 24 September 2018 - 07:17 PM

I suggest your database is not complete. In the first table you defined a record:
3....A....0
but you do not show any names(records) which meet the criteria for
A....0

You should have additional records in table two such as:
51....Nick......A....0
52....Marios....A....0
53....Andrea....A....0

When new records are added, look for ones that are in both of the first two groups and then add a record showing it in the 3rd group.
0

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic