Filemaker Question. I need to create one table from the dataset of three tablesFilemaker 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
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
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)
- 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
asked Mar 7 at 7:53
Joshua VittachiJoshua Vittachi
31
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)
- 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
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)
- 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
asked Mar 7 at 7:53
Joshua VittachiJoshua Vittachi
31
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)
- 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
filemaker
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
asked Mar 7 at 7:53
Joshua VittachiJoshua Vittachi
31
asked Mar 7 at 7:53
Joshua VittachiJoshua Vittachi
31
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 |
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
Well, what have you tried so far?
– Stephen
Mar 7 at 8:04
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
@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
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
@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 |
1 Answer
1
active
oldest
votes
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.
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
);
);
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
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
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
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.
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.
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.
answered Mar 7 at 11:13
AndreasTAndreasT
1,85411113
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.
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
answered Mar 7 at 11:13
AndreasTAndreasT
1,85411113
1,85411113
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
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
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
Required, but never shown
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
Required, but never shown
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
Required, but never shown
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
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
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