I am putting working out a locker database for our school. The locker inventory, student name etc... I can figure out, however, each locker has 5 possible combinations that can be assigned. It seems like a radio button field would be the choice, however that would be a lot of value lists. Additionally, I don't think they would show up in a columnar solution. Could use some guidance on this.

Thanks for your help in Advance

Norm

Consider a separate file that contains three fields, the locker number, the combination, and a "select" field. So you would have 5 records in this file related to each locker. You could display the 5 records in a portal in the main file, with the select field displayed as a checkbox. Or, you could have a combination field in the main file, that pops up a value list or displays radio buttons based on a related value list from the new file. So, it would only be a single value list, but it would be unique to each locker record.

Thanks, this was a lot of help. I love learning new things in FM. You are all great!

Norm