Counting records

[Jason Campbell]

I need to be able to filter records including and between character values specified in drop down menu that reference primary IDs in another table.

Each character type room number, has been mapped with an integer in the rooms table.

Example:

Parent table has drop down menu for first room = 7a  another drop down menu selects last room =  9b

The filtered child records returned include:

7a

7b

7c

8a

8b

8c

9a

9b

I would also like to be able to exclude 1 room from within the range, and add 1 room from outside of the range:

ExcludeRoom = 8c

AddRoom = 12b

The filtered results would then look like:

7a

7b

7c

8a

8b

9a

9b

12b

Thanks

[ParaSQL Support]

If I understand the question correctly, you should be able to specify a Master Filter on the child record with room = 12b and room not equal 8c. The master filter is applied in conjunction with other filters.

[Jason Campbell]

I have tried this advanced filter:

SELECT RoomNum

FROM Rooms

WHERE Rooms.RoomNum BETWEEN Assignment.ToRoom AND Assignment.FromRoom

It only returns one record when I am expecting several

I have also tried a normal filter matching all:

Rooms.RoomNum Greater Than or Equal To @Value(Assignment.ToRoom)

Rooms.RoomNum Less Than or Equal To @Value(Assignment.FromRoom)

[Robert Dyas]

To really understand the issue I think we will have to set a time for a screen share. 

Please contact sup...@parasql.com to schedule a time.