I'm between a rock and a hard place with a project here. Hopefully this is the right area to post this.
Basically, I am trying to create and access a graphical user interface for a floor plan.
The two Access 2010 tables in question are the Booth Master with one record for each building (fields example: building=A, numberRows=20, numberColumns=8) and a Booth Detail with one record for each booth (fields example: building=A, booth=101, inRow=2, inColumn=1)
The end result I want from the long list of booths (Booth Detail) is a grid looking "thing" that can be clicked ideally. The "thing" would have (as in the above example) 160 blocks of some kind in 20 rows, 8 columns per row. Each block would represent a booth or empty floor space.
I do know how to do conditional programming to change colors. But I want them to be able to click on one of the blocks to show info about that booth (ie - Booth number, whether it is sold, who has it, etc) and the ability to onClick generate a "you bought this" record to a transaction table.
A lot of this I would be able to do, if I could dynamically look at the Booth Master, generate some kind of grid, and fill it in with info from the Booth Detail.
Please let me know if I need to explain more completely.
Thanks.
Basically, I am trying to create and access a graphical user interface for a floor plan.
The two Access 2010 tables in question are the Booth Master with one record for each building (fields example: building=A, numberRows=20, numberColumns=8) and a Booth Detail with one record for each booth (fields example: building=A, booth=101, inRow=2, inColumn=1)
The end result I want from the long list of booths (Booth Detail) is a grid looking "thing" that can be clicked ideally. The "thing" would have (as in the above example) 160 blocks of some kind in 20 rows, 8 columns per row. Each block would represent a booth or empty floor space.
I do know how to do conditional programming to change colors. But I want them to be able to click on one of the blocks to show info about that booth (ie - Booth number, whether it is sold, who has it, etc) and the ability to onClick generate a "you bought this" record to a transaction table.
A lot of this I would be able to do, if I could dynamically look at the Booth Master, generate some kind of grid, and fill it in with info from the Booth Detail.
Please let me know if I need to explain more completely.
Thanks.
