0

Two questions

Hi All,

I have many remote dslr camera trap “setups” for monitoring mountain lions in Southern California. Each setup comprises of multiple components: Camera box, camera, lens, sensor(s), flash(es) etc. 

I have tables of all of the components - for example: Camera table includes camera label, serial #, model # etc. and a location field.

Other tables for other components are similar.

Two questions:

1) If I create a setup, I will give it a location of say, “Barham Blvd”. I would like that location to automatically update the Location field of all of the components of that setup. Is that possible?

2) If I am creating a new Setup record, and I get a list of cameras to choose from - can cameras that are already in other setups be greyed out, or only cameras that are available be in green or something? In other words, how do I make components of my setups only be available in one setup?

Currently, I manually enter the Location into each component  record - which is not ideal. 

Secondly, any component that has the Location as “Office” means it is available for use. How can I exploit that?

Insights welcome and appreciated.

 

Roy.

3 replies

null
    • Alain_Fontaine
    • 3 yrs ago
    • Reported - view

    If you create a reference between the “Components” table and the “Setup” table:

    1) when a component is part of a setup, the location attached to the setup will be visible from each component (that“s what relational databases are made for);

    2) in Ninox, when choosing an component to be added to a setup, only the free components will be shown.

    • Roy Dunn Photography
    • Roy_Dunn
    • 3 yrs ago
    • Reported - view

    Thanks a bunch, and not quite so fast... :)

    1) I have a table for Locations, which I reference in my Setups Table, and also in my Components tables. How should I configure this differently?

    2) Clearly I have done something wrong - If I create a new Setup record, I have the full choice of components, regardless of whether they have been used elsewhere.

    I am a 59 year old Luddite. I am a pretty decent photographer, but lousy programmer - please make the necessary allowances :)

    Much appreciated

    Roy.

    • Alain_Fontaine
    • 3 yrs ago
    • Reported - view

    So, you have a “Locations” table, and references (N:1) to it from the two other tables. Do you have a reference (N:1) from the “Components” table to the “Setups” table? If this is the case, you don“t need the reference from ”Components“ to ”Locations“ anymore, because, in the ”Components“ table, you can reference the fields of the location referred to by the setup by writing ”Setups.Locations.<any field in Locations>“.

Login to reply

Content aside

  • 3 yrs agoLast active
  • 3Replies
  • 371Views