Search Screen with different Edit Screens

[ruiascensao]

Hi,

I have a database of IT assets. The asset can have different status (In use/in maintenance/waiting parts/faulty).
For this status I have forms (in use/maintenance/wparts/faulty). These forms use the same table but the edit screen just shows the necessary field for that status.
I world like to do different according to the status:

searchedit.jpg (46.76 KiB) Viewed 4428 times

Is this possible?

Best Regards,
Rui

[shane]

one way to achieve what you need is to have the same form, but simply have display conditions on each object.

Assuming that the Asset Status is called asset_status in the database, the display condition needs an SQL result of either 0 or 1.

Code: Select all

SELECT IF('#asset_status#' < 1,'1','0')

or

Code: Select all

SELECT IF('#asset_status#' <> 1,'1','0')

[ruiascensao]

Hi Shane,

I'm using:

Code: Select all

SELECT IF('#unit_status_id#' = 14fb0e1f28ca54,'1','0')

But I have the error:

"SQL

SELECT IF('14f84453ade474' = 14fb0e1f28ca54,'1','0')
Transaction

No Transaction.
Error

1054: Unknown column '14fb0e1f28ca54' in 'field list'"

Any idea?
Thank You!
Rui

[massiws]

ruiascensao ,

if you want to check the id (#unit_status_id#), maybe a solution could be:

Code: Select all

SELECT IF('#unit_status_id#' = '14fb0e1f28ca54','1','0')

Hope this helps.

[admin]

rui,

massiws is right, you simply forgot to put the ID in quotes (making it a string).

Steven

[ruiascensao]

Hi,

Thank you!
It's working.

Regards,
Rui

[admin]

.