Jump to content
Sign in to follow this  
Andrew5

How to use data tunneling?

Recommended Posts

Long ago, pre-GUI, I programmed DB's, all flat or one to many relationship type. I am making some FM solutions, and guess what, everything is a one-to-many relationship with everything one hop away, just like I did 25 years ago. My daily use DB is following: central record is client, clients can repeat but they get a new record in the main table. Related to the main table, 1 hop away 1-to-many tables for: 1- time used, 2- client account #1, 3- client account #2. There are a bunch of layouts for reports & forms.

- I see everything I make as 1 hop away. I can and I have been able to make all my solutions that way, just as i did long ago, but am I missing something here in terms of usefulness?

Share this post


Link to post
Share on other sites

FileMaker has advanced a great deal since it was a flat file system. You need to invest in a good book like Fm9 Bible and study it. you will be amazed.

Share this post


Link to post
Share on other sites

yes, "one hop away" is still enough for most solutions

and "two hops away" can come in handy:

e.g a client has orders, and each order has items

so from clients, you can now "see" all items

greg

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.