Assignment

austinl · Post by **austinl** » Mon Jun 16, 2014 2:06 am

I have two tables set up. One is for radios and the other is for radio assignment. On the radio assignment there is a returned button. How can I use the check duplicate button to make it so the same radio cannot be assigned when it is already assigned, but it can be reassigned when it is marked returned. I wold like to keep the records instead of deleting them.

scs · Post by **scs** » Mon Jun 16, 2014 6:03 am

And another field (eg. datetimereturned) as part of key field will do.

austinl · Post by **austinl** » Mon Jun 16, 2014 10:22 am

How would that work so when the radio is returned it can be reassigned? I am very sorry for not understanding.

mobhar · Post by **mobhar** » Tue Jun 17, 2014 2:17 pm

Post your table schema, and
Describe us by using one simple example.

austinl · Post by **austinl** » Thu Jun 19, 2014 2:18 am

A radio will be signed into the system with no duplicates. It will then be signed out and cannot be reassigned until it is marked as "Yes" for returned. Then the radio will be able to be reassigned without deleting the record.

== Table structure for table radios

== Table structure for table resource_assignment

mobhar · Post by **mobhar** » Fri Jun 20, 2014 12:43 pm

Unfortunately, you did not mention which fields from the table schema that will be involved by using the radio button control.

austinl · Post by **austinl** » Fri Jun 20, 2014 9:24 pm

The returned field in resource_assignment.

mobhar · Post by **mobhar** » Sun Jun 22, 2014 7:36 am

Which field, exactly?