Smart Portal

[dennisj]

I have a Jobs table with a number (50 to 100) of records (Part Number, Job Number, etc.)

 

In another Table I have a portal to the Jobs table. I would like the portal to show a sub-set of the Jobs table based on the contents of a global (g PN) field.

 

If I had the following part numbers in the Jobs table:

 

1234

1235

1245

2346

 

and g PN contained "123", the portal would show 1234 & 1235.

if g PN contained "12", the portal would show 1234, 1235, & 1245.

if g PN contained "*5*", the portal would contain 1235 & 1245. (This one is a bonus.)

 

It would be nice if this was live, as characters are entered into g PN, the items in the portal update. Again, a bonus.

 

Any ideas or links to resources are welcome.

 

Regards,

 

Dennis

[David Head]

In the Jobs table, you need a calculation that creates a multi-key from the Job number. The nature of that calculation will depend on the possible length of the job number. It is best done with a recursive custom function. However, this may give you some ideas for a four digit job number:

 

Left ( jobno; 1 ) & ¶ &

Left ( jobno; 2 ) & ¶ &

Left ( jobno; 3 ) & ¶ &

Left ( jobno; 4 ) & ¶ &

"*" & Middle ( jobno; 1; 1 ) & "*" & ¶ &

"*" & Middle ( jobno; 2; 1 ) & "*" & ¶ &

"*" & Middle ( jobno; 3; 1 ) & "*" & ¶ &

"*" & Middle ( jobno; 4; 1 ) & "*"

 

For a job number 5674, this would produce:

 

5

56

567

5674

*5*

*6*

*7*

*4*

 

This would be related to your global field. Entering the sort of data you have mentioned will filter the portal as required. But it will not be live as you type - you will need to commit the entry for the updated list of records.