Filemaker Question. I need to create one table from the dataset of three tables2019 Community Moderator ElectionFilemaker 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
Virginia employer terminated employee and wants signing bonus returned
Grey hair or white hair
Is having access to past exams cheating and, if yes, could it be proven just by a good grade?
Can someone explain what is being said here in color publishing in the American Mathematical Monthly?
How to pass a string to a command that expects a file?
How do I express some one as a black person?
infinitive telling the purpose
In the late 1940’s to early 1950’s what technology was available that could melt a LOT of ice?
Do I really need to have a scientific explanation for my premise?
Accountant/ lawyer will not return my call
How are such low op-amp input currents possible?
What Happens when Passenger Refuses to Fly Boeing 737 Max?
Should I tell my boss the work he did was worthless
"One can do his homework in the library"
Could a cubesat propel itself to Mars?
How much attack damage does the AC boost from a shield prevent on average?
Unreachable code, but reachable with exception
Peter's Strange Word
Aliens englobed the Solar System: will we notice?
Is "history" a male-biased word ("his+story")?
Fourth person (in Slavey language)
Is Gradient Descent central to every optimizer?
Force user to remove USB token
Why would a jet engine that runs at temps excess of 2000°C burn when it crashes?
Filemaker Question. I need to create one table from the dataset of three tables
2019 Community Moderator ElectionFilemaker 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
New contributor
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
New contributor
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
New contributor
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
New contributor
New contributor
New contributor
asked Mar 7 at 7:53
Joshua VittachiJoshua Vittachi
31
31
New contributor
New contributor
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.
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
);
);
Joshua Vittachi is a new contributor. Be nice, and check out our Code of Conduct.
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.
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.
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.
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
1,85411113
add a comment |
add a comment |
Joshua Vittachi is a new contributor. Be nice, and check out our Code of Conduct.
Joshua Vittachi is a new contributor. Be nice, and check out our Code of Conduct.
Joshua Vittachi is a new contributor. Be nice, and check out our Code of Conduct.
Joshua Vittachi is a new contributor. Be nice, and check out our Code of Conduct.
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