Sub-form dynamic requering Customer field

[Gregof1976]

Hello

I would like to ask for support for my new data base.

The data base work properly but I would like to add another functionality that will help collect data in better way. Unfortunetelly so far I didn't find possible solution


In the subform 'FormWprG' are being filled:

• Day
• Hours
• Shift
• ProjectName
• Customer

And what I would like to achieve is after choosing 'ProjectName', field 'Customer' will be limited only to scope of this project.

For example if I choose: Project 1
In the field Customer I should have only two option for ClientName: GM or FIA

Example is attached.

Thanks for any support
Greg