Faria Geplaatst: 25 juni 2018 Delen Geplaatst: 25 juni 2018 Hello, Im in need of some assistance. Im fairly new to Filemaker and Im trying to do show some information that It aint showing. Basically I have: A form for the invoices and I want to show the company name on it. Already filled in within the forecast table, but I cant seem to get that value in the projects form and in the invoice forms. Every time I try to get a value from 2 tables away it doesnt work. Am I missing something? Regards, Quote Link naar reactie
Banach Geplaatst: 25 juni 2018 Delen Geplaatst: 25 juni 2018 Check your relations as well as the contents of the key fields. I suspect you are using autoentered values using relations that are not yet valid. Do CompanyID, ForecastID etc have the expected values? See the attached file that proofs that getting data from more than one table away should be no problem. data2tables.fmp12 Quote Link naar reactie
Faria Geplaatst: 25 juni 2018 Auteur Delen Geplaatst: 25 juni 2018 (aangepast) In the Forecast I cant get the Companies Name. In Projects I can get the Forecast associated to it. But I cant get the company Name with the Invoice associated with the project. To specify I want an already filled field that was designated in Forecasts. 25 juni 2018 aangepast door Faria Quote Link naar reactie
Banach Geplaatst: 25 juni 2018 Delen Geplaatst: 25 juni 2018 So then it seems that the relationship between projects and invoices is not fulfilled. Does projectID in Invoices contain the correct Project id, can you get the project name into the invoice? Quote Link naar reactie
Faria Geplaatst: 27 juni 2018 Auteur Delen Geplaatst: 27 juni 2018 Yes. I can get the project name. and Within the project layout I can get the company name. But in Invoices I cannot get the company. Quote Link naar reactie
Banach Geplaatst: 27 juni 2018 Delen Geplaatst: 27 juni 2018 Are the ProjectID fieldtypes in projects and invoices the same and compatible with the contents? Quote Link naar reactie
Peter Wagemans Geplaatst: 29 juni 2018 Delen Geplaatst: 29 juni 2018 Hello Faria, maybe it would help if you copy and paste those 4 tables in a "lab scale" file. Just go to the table definitions dialog, select the 4 tables, copy, paste in a new file. Make the relations again between the table occurrences. After pasting a table, the table is empty. Add a few records everywhere so we have some data to work with. Maybe remove the fields you think are irrelevant and none of our business Doing this has 2 advantages. It makes you re-apply the logic, and think it over. And it helps us as well, because if you upload that file, we will probably very quickly be able to identify the problem. Quote Link naar reactie
Faria Geplaatst: 5 juli 2018 Auteur Delen Geplaatst: 5 juli 2018 Hello, I managed to find the problem. It was due to a relation. Because you cant have 2 tables related to one, weird enough, So I made a workaround in terms of connections and made it work. Thank you Quote Link naar reactie
hbrendel Geplaatst: 5 juli 2018 Delen Geplaatst: 5 juli 2018 (aangepast) 1 uur geleden zei Faria: It was due to a relation. Because you cant have 2 tables related to one, weird enough, So I made a workaround in terms of connections and made it work. Please elaborate. I don't understand anything of this statement. In my perception you can have as many tables related to one as you ever would like. And what is "a workaround in terms of connections"? 5 juli 2018 aangepast door hbrendel Quote Link naar reactie
Faria Geplaatst: 5 juli 2018 Auteur Delen Geplaatst: 5 juli 2018 Ok. In the previous tables I shown, you can see in th eForecast Table the SharkID, it corresponds to a Shark table. So, you have that connection, one Shark is in charge of a Forecast. Then, There is a parallel table Timesheet, connected to the table Projects, whre you can say, a Shark recorded X hours in a project Y. Not the same shark set up previously. So in the Timesheet table, you also have a SharkID, And THAT connection is not possible in Filemaker. In a normal DB system it is possible, not here though, therefore I just removed that connection, and it started to work again. I kinda not know why though. Filemaker isnt making much sense to be honest. Quote Link naar reactie
Banach Geplaatst: 5 juli 2018 Delen Geplaatst: 5 juli 2018 59 minutes ago, Faria said: In a normal DB system it is possible, I don't think that other DB systems than FileMaker are 'normal' ? Quote Link naar reactie
Aanbevolen berichten
Doe mee aan dit gesprek
Je kunt dit nu plaatsen en later registreren. Indien je reeds een account hebt, log dan nu in om het bericht te plaatsen met je account.