I can't set a boolean on a Datatype

Need help Database
1

I have a double glazing app and a user can;

  1. Create window
  2. Choose it’s layout style (this is the number of panes of glass)
  3. Choose if any of the panes of glass should open (Opener = Yes/No)
  4. Choose opener direction (Left, Right, Up, Down)

I can’t figure out how to do step 4. If anyone has 2 mins to watch this video of my setup/issue that would be amazing!

My DB set up is;

Datatype: Window
Style [option set list of styles 1x1, 1x2, 1x3 etc]

Datatype: WindowPanes
Field: Pane (option set list to choose a pane A1, A3, A3 etc)

Datatype: PaneOpener
Field: Opener = Yes/No

Workflow;

When a window pane is clicked, I have a popup which will allow the users to choose the direction of the opener. I don’t know how to ‘connect’ that opener direction with the correct pane. Also, if a user edits the openers direction, I don’t want a new pane to be created, the same window pane should simply have a new open direction.

2

Hi there, @darren.james7518… if I understand the video correctly, I’m not sure why you need the New_PaneOpener data type. Can’t you put an opener field (yes/no) and an opener direction field on the New_WindowPanes data type? Because you are “working with” a particular Pane in that data type (i.e., A1, A2, A3, etc.), it makes sense (to me, at least) to also capture in that data type whether the particular pane is an opener and if it is, the direction in which it opens. What do you think?

Best…
Mike

3

@mikeloc Thank you for taking the time to review the video and give some advice, you may be correct. I am currently working on the window resizing and later/tomorrow I will go back to this boolean issue and look at your suggestion/thoughts. Thanks though, I got totally confused by this!

1 Like