need help with relationship

[solarpunk]

Hello,

I was wondering if someone can help. I am creating two databases, one is call Daily Inquiries and the other one is call Funding. I want to create the same nformation that get created in Daily Inquiries to Funding. Each databases has the id which i create, call ClassID to connect them.

Any help would be really appreciate it.

Thanks,

Victor

[dbruggmann]

Why do you want to duplicate the information?

Instead you could use a portal in Funding (or just dsplay the related fields), which shows the matching information of Daily Inquiries and over the reationship of this portal you can also do all calculations etc. needed.

[solarpunk]

Well,

The reason being is that same information right now get imported to manually. So instead of doing that we want be able to update from any database so that the different department can see it and update if they have to.

Here is example of what we use right now. Basically we have a daily inquiries database and also enrollement Database, and Student database. the data get imported from Daily Inquieres in to Enrollement database to Student Database. IF a change is made in Student database, this change is not reflect in Daily inquirie or Enrollment Database. I just want to stop the importing of information from one database by using relationship. i know a little bit about portal, i will look into that.

So i just want to pass the information from one database to another and allow the employee to make change to it if they need to update a person record.

Thanks,

Victor

[dbruggmann]

Hi Victor

The first goal for setting up a relational database should be to avoid duplicated data as far as possible (database = the whole Filemaker solution). With Filemaker you accomplish this by creating a separate file for every kind of subject you want to store data about and linking them with relationships.

I'm not sure if I understand your actual database setup and purpose, but mainly because of the foreign language.

Nevertheless I'll try it:

If you register a contact in the file