Jump to content
Sign in to follow this  
agtjazz

2 databases sharing data

Recommended Posts

I am working on 2 databases and I am trying to share the data within each of them. In the first database, it basically tracks incoming items (called an inlog). It's a very simple database as the fields are date in, date out, from, to, title, form-type, comments etc. In the second database, it will track grants. So if a grant comes in, it will be entered in the inlog database first (with the form-type of grant) and I wish to see these entries in the grant database (but not the other types of forms that were entered in the inlog database).

How is this best accomplished?

Share this post


Link to post
Share on other sites

I don't think that you should have 2 databases (which, by FM definition is two unrelated FM files).

Why not just find log items by form type = Grant?

or..if you want to get fancy, use Graham's method. Link

Share this post


Link to post
Share on other sites

I think I am attempting the "fancy" method (Graham's)... and am stuck. So in 1 database, one table will track items coming into the office (called an inlog) and one table will expand on the details of the grants (one of the items that comes in the inlog table).

So is it a related record that I need to create to get the details of the grant?

I have attached a mockup of the database design I am trying..... I studied the CHN_inventory_fej db that Fenton put up as an example, but think I am missing some concepts.

Any assistance is greatly appreciated.

Inlog.fp7.zip

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.