Displaying Data From Two Tables/Data Types At Once

Need help Database
1

I’ve three Tables/Data Types

User Profile: It has first name, last name, telephone number of the user linked to user’s email id
Job Posting: It has employer email id
Applicant Details: It has applicant email id

Now inside a Repeating Group or Table, I’ve to display
For Job Posting: User Profile such as first name, last name, telephone number where email id = employer email id
For Applicant Details: User Profile such as first name, last name, telephone number where email id = applicant email id

How to display data from two Tables/Data Types, where as the Table element or the Repeating Group element do a search on a single table?

2

What is the goal to show one repeating group of what? a list of all job postings or a list of all applicants or a list of all applicants for each job posting an employer posted?

3

Job posting details will be displayed in one repeating group and applicant details in another repeating group. Need to display user profile details such as first name, last name and telephone number in Job posting repeating group and applicant repeating group where user profile email id = employer email id and user profile email id = applicant email id respectively.

4

Any solutions to above issue, please?

5

Thanks for the reply. Solved using relations between database tables.

1 Like