Ufdjrw

Is there a single word describing earning money through any means?

Create all possible words using a set or letters

When a Cleric spontaneously casts a Cure Light Wounds spell, will a Pearl of Power recover the original spell or Cure Light Wounds?

Why did the EU agree to delay the Brexit deadline?

Which one is correct as adjective “protruding” or “protruded”?

Is it possible to have a strip of cold climate in the middle of a planet?

I am looking for the correct translation of love for the phrase "in this sign love"

What does chmod -u do?

How do you respond to a colleague from another team when they're wrongly expecting that you'll help them?

What is Cash Advance APR?

Why electric field inside a cavity of a non-conducting sphere not zero?

Problem with TransformedDistribution

Aragorn's "guise" in the Orthanc Stone

Fear of getting stuck on one programming language / technology that is not used in my country

If a character has darkvision, can they see through an area of nonmagical darkness filled with lightly obscuring gas?

How can we generalize the fact of finite dimensional vector space to an infinte dimensional case?

Should I outline or discovery write my stories?

What is the evidence for the "tyranny of the majority problem" in a direct democracy context?

Strong empirical falsification of quantum mechanics based on vacuum energy density

The screen of my macbook suddenly broken down how can I do to recover

The IT department bottlenecks progress. How should I handle this?

Has any country ever had 2 former presidents in jail simultaneously?

Can someone explain how this makes sense electrically?

Melting point of aspirin, contradicting sources

Filemaker Question. I need to create one table from the dataset of three tables

Filemaker 12: multiple search criteria in one viewUse field from most recent record based on one-to-many relationship - Filemaker Pro 11Is it possible to create table templates in Filemaker?Filemaker GetSummary from related tableIssue with XSL Template for Dates from Filemake Exported DataCreating Keyword/Tag System in FileMaker 14How to rename file on upload to server using RecordID from Filemaker ServerFileMaker 14 Pro Two Tables One Date RangeFileMaker - Getting Data From Another Table with Multiple Field RestrictionsPerform analysis on last three values of a FileMaker dataset

0

So I have three tables

1.Studentdata - user id, username(1), fname, sname, location_id(2) ...

2.Recent_Logins - username(1), login date (In 6 months)

3. location - location_id (2), location_name

---

Relationships denoted by (1) & (2).

---

My Final table should have the usernames from Table 1 that do not show in Table 2 shown as follows:

---

Location_name

username, Fname, sname, email, number

---

filemaker

share|improve this question

asked Mar 7 at 7:53

Joshua VittachiJoshua Vittachi

31

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Well, what have you tried so far?
  
  – Stephen
  Mar 7 at 8:04
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @Stephen, Hey, I am brand spanking new to filemaker so I have tried nothing; my coding knowledge isn't great right now either tbh.
  
  – Joshua Vittachi
  Mar 7 at 8:11
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Well, what you want to do is a SQL JOIN. There are a lot of easy SQL tutorials available if you Google for them which will explain it easily and you won't have to wait around for an answer here. For example look on the W3Schools website.
  
  – Stephen
  Mar 7 at 8:13
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @JoshuaVittachi If you're new to Filemaker, I recommend you join one (or more) of the forums dedicated to the platform. Stack Overflow is not a good place for this type of questions - in fact, your question is not about programming and as such is off-topic here.
  
  – michael.hor257k
  Mar 7 at 11:44
  
  

  
  
  
  

add a comment | 

0

So I have three tables

1.Studentdata - user id, username(1), fname, sname, location_id(2) ...

2.Recent_Logins - username(1), login date (In 6 months)

3. location - location_id (2), location_name

---

Relationships denoted by (1) & (2).

---

My Final table should have the usernames from Table 1 that do not show in Table 2 shown as follows:

---

Location_name

username, Fname, sname, email, number

---

filemaker

share|improve this question

asked Mar 7 at 7:53

Joshua VittachiJoshua Vittachi

31

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Well, what have you tried so far?
  
  – Stephen
  Mar 7 at 8:04
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @Stephen, Hey, I am brand spanking new to filemaker so I have tried nothing; my coding knowledge isn't great right now either tbh.
  
  – Joshua Vittachi
  Mar 7 at 8:11
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Well, what you want to do is a SQL JOIN. There are a lot of easy SQL tutorials available if you Google for them which will explain it easily and you won't have to wait around for an answer here. For example look on the W3Schools website.
  
  – Stephen
  Mar 7 at 8:13
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @JoshuaVittachi If you're new to Filemaker, I recommend you join one (or more) of the forums dedicated to the platform. Stack Overflow is not a good place for this type of questions - in fact, your question is not about programming and as such is off-topic here.
  
  – michael.hor257k
  Mar 7 at 11:44
  
  

  
  
  
  

add a comment | 

So I have three tables

1.Studentdata - user id, username(1), fname, sname, location_id(2) ...

2.Recent_Logins - username(1), login date (In 6 months)

3. location - location_id (2), location_name

---

Relationships denoted by (1) & (2).

---

My Final table should have the usernames from Table 1 that do not show in Table 2 shown as follows:

---

Location_name

username, Fname, sname, email, number

---

filemaker

share|improve this question

asked Mar 7 at 7:53

Joshua VittachiJoshua Vittachi

31

username, Fname, sname, email, number

share|improve this question

asked Mar 7 at 7:53

Joshua VittachiJoshua Vittachi

31

share|improve this question

asked Mar 7 at 7:53

Joshua VittachiJoshua Vittachi

31

asked Mar 7 at 7:53

Joshua VittachiJoshua Vittachi

31

asked Mar 7 at 7:53

Joshua VittachiJoshua Vittachi

31

1 Answer
1

active

oldest

votes

1

This is fairly easy to do in FileMaker. No need to mess with any SQL join's that was suggested. It's purely point and click.

If you have your data in CSV or an Excel sheet, you can import your data directly into 3 tables in FileMaker and have it set up the fields automatically for you if you have a header column with names in your data.

If not, create the 3 tables manually in the Manage Database dialog and create the needed fields.
Move over to the Relationship panel and note the 3 boxes there. Each box represent a table you have just created. Each box show the fields in each table. Drag a line from each source field to a destination field in the other table(s).
That's pretty much it data-wise, for starters.
Press Ok to save the setup.

When you created the tables, 3 layouts were also created. Go to your main layout (Studentdata) and you should see your Studentdata fields there in a basic form.
Now you can add portals to the other 2 tables you have and be able to see and manipulate the related data.
Choose the portal tool form the toolbar or menu and draw out a portal. Select from which relationship you wish to show the data and choose your fields for display/data entry.

Save your layout and you should be set. You may need to adjust your relationships as to sorting order, create ability and so on.

You can create any number of layouts to represent the views of the data that you need, containing only the fields you are interested in.

You can make calculation fields that concatenate fields and do any kind of data manipulation.

share|improve this answer

answered Mar 7 at 11:13

AndreasTAndreasT

1,85411113

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55038644%2ffilemaker-question-i-need-to-create-one-table-from-the-dataset-of-three-tables%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

1

This is fairly easy to do in FileMaker. No need to mess with any SQL join's that was suggested. It's purely point and click.

If you have your data in CSV or an Excel sheet, you can import your data directly into 3 tables in FileMaker and have it set up the fields automatically for you if you have a header column with names in your data.

If not, create the 3 tables manually in the Manage Database dialog and create the needed fields.
Move over to the Relationship panel and note the 3 boxes there. Each box represent a table you have just created. Each box show the fields in each table. Drag a line from each source field to a destination field in the other table(s).
That's pretty much it data-wise, for starters.
Press Ok to save the setup.

When you created the tables, 3 layouts were also created. Go to your main layout (Studentdata) and you should see your Studentdata fields there in a basic form.
Now you can add portals to the other 2 tables you have and be able to see and manipulate the related data.
Choose the portal tool form the toolbar or menu and draw out a portal. Select from which relationship you wish to show the data and choose your fields for display/data entry.

Save your layout and you should be set. You may need to adjust your relationships as to sorting order, create ability and so on.

You can create any number of layouts to represent the views of the data that you need, containing only the fields you are interested in.

You can make calculation fields that concatenate fields and do any kind of data manipulation.

share|improve this answer

answered Mar 7 at 11:13

AndreasTAndreasT

1,85411113

add a comment | 

1

This is fairly easy to do in FileMaker. No need to mess with any SQL join's that was suggested. It's purely point and click.

If you have your data in CSV or an Excel sheet, you can import your data directly into 3 tables in FileMaker and have it set up the fields automatically for you if you have a header column with names in your data.

If not, create the 3 tables manually in the Manage Database dialog and create the needed fields.
Move over to the Relationship panel and note the 3 boxes there. Each box represent a table you have just created. Each box show the fields in each table. Drag a line from each source field to a destination field in the other table(s).
That's pretty much it data-wise, for starters.
Press Ok to save the setup.

When you created the tables, 3 layouts were also created. Go to your main layout (Studentdata) and you should see your Studentdata fields there in a basic form.
Now you can add portals to the other 2 tables you have and be able to see and manipulate the related data.
Choose the portal tool form the toolbar or menu and draw out a portal. Select from which relationship you wish to show the data and choose your fields for display/data entry.

Save your layout and you should be set. You may need to adjust your relationships as to sorting order, create ability and so on.

You can create any number of layouts to represent the views of the data that you need, containing only the fields you are interested in.

You can make calculation fields that concatenate fields and do any kind of data manipulation.

share|improve this answer

answered Mar 7 at 11:13

AndreasTAndreasT

1,85411113

add a comment | 

This is fairly easy to do in FileMaker. No need to mess with any SQL join's that was suggested. It's purely point and click.

If you have your data in CSV or an Excel sheet, you can import your data directly into 3 tables in FileMaker and have it set up the fields automatically for you if you have a header column with names in your data.

If not, create the 3 tables manually in the Manage Database dialog and create the needed fields.
Move over to the Relationship panel and note the 3 boxes there. Each box represent a table you have just created. Each box show the fields in each table. Drag a line from each source field to a destination field in the other table(s).
That's pretty much it data-wise, for starters.
Press Ok to save the setup.

When you created the tables, 3 layouts were also created. Go to your main layout (Studentdata) and you should see your Studentdata fields there in a basic form.
Now you can add portals to the other 2 tables you have and be able to see and manipulate the related data.
Choose the portal tool form the toolbar or menu and draw out a portal. Select from which relationship you wish to show the data and choose your fields for display/data entry.

Save your layout and you should be set. You may need to adjust your relationships as to sorting order, create ability and so on.

You can create any number of layouts to represent the views of the data that you need, containing only the fields you are interested in.

You can make calculation fields that concatenate fields and do any kind of data manipulation.

share|improve this answer

answered Mar 7 at 11:13

AndreasTAndreasT

1,85411113

share|improve this answer

answered Mar 7 at 11:13

AndreasTAndreasT

1,85411113

answered Mar 7 at 11:13

AndreasTAndreasT

1,85411113

answered Mar 7 at 11:13

AndreasTAndreasT

1,85411113