Forum Discussion

BobThomas1's avatar
BobThomas1
Qrew Cadet
2 years ago

Getting fields from other tables & insert into one form

Getting fields from other tables & insert into one form

I have five images (1-5) and also a part of a relationship diagram showing the three tables the data comes from.

HREmployees are the workers who are assigned hardware (Software will be next to do, but for now just hardware.) 

The first image is an Assignment chart that is on the form. The one employee has two assignment pieces of hardware. BUT only one has a serial number, so the second piece of hardware will be blank.  So the actual hardware for the serial number is (AHL-LAP-2433 - Laptop - Hewlett-Packard HP - ProBook 445 14 inch G9 Notebook PC - Win 11 Pro x64) 

Image 2 are the four fields that make up the HardwareDetail field I created, a formula text and is the Hewlett-Packard HP.

Image 3 is the HR employee that the Hewlett-Packard HP is assigned to.

Image 4 shows the serial number for the Hewlett Packard HP. Note the HR Employee has two assignement hardware records, but there is no physical hardware for her second record, so it will show blank for HardwareDetail field. In the upper right is a text label I added to the form, but have been unable to get the HardwareDetail field to display after the text label.

Image 5 - shows what I want in the rectangle box to show which it isn't. The data chart on the left will be removed so that the rectangle box will take up the space of the deleted data chart.

Final image are the three tables that have relationships. I'm just showing these three tables as there are extensive lines from other tables and it is rather a confusing array of tables & relationships. Hopefully our team can make changes that will help simplify this app.

Hopefully the images help explain. Thanks.



------------------------------
Bob T.
------------------------------
Relationships

2 Replies

Sort By
  • BobThomas1's avatar
    BobThomas1
    Qrew Cadet
    2 years ago
    The images may not be in order, and the names are changed. The first image is the one with the red circle around Assignment.

    2nd image has a red circle around Hardware.

    3rd image has a red circle around HR-Employees & I have covered up the employees email address in red.

    4th & 5th images are the HR-Employees form and the HardwareDetail info (Hewlett-Packard HP...) data that I want to show in the form.

    ------------------------------
    Bob T.
    ------------------------------
    • BobThomas1's avatar
      BobThomas1
      Qrew Cadet
      2 years ago
      I solved the issue. 

      After creating a new relationship, to add to the (I think) too many and perhaps duplicate ones (that I may suggest be cleaned up in the near future) I was able to get the computer hardware information to show up. 

      I created a new embedded report as that is the way the data was being presented. But the computer name, Model, Operating System data was not in the assignment table report. So I copied the embedded report and after putting all the computer hardware data, put it all in a new formula text field I had created yesterday.

      All works good, (see image). I then deleted the table relationship I had setup as it was not part of the solution but rather part of the App cleanup needed.

      This thread can be closed.

      ------------------------------
      Bob T.
      ------------------------------