Jalz Posted December 2, 2005 Share Posted December 2, 2005 Hi Guys, Im working on a new project, and for once I've decided to sit down and plan out my database on paper before creating it in FMA8. Ive attached a very basic sample of my relationships. In the diagram you can see the relationship: subjobs------ How do I reverse it so that I can have subjobs>------status Thanks as always Link to comment Share on other sites More sharing options...
Ender Posted December 2, 2005 Share Posted December 2, 2005 Add a Status field to Subjobs and relate Subjobs::Status = Status::StatusName. The Status table may not be necessary if StatusName is the only field (and it's not the source of a value list.) You could keep the interface for looking up Jobs by Status in a layout based on the Jobs table, and use a global gStatus as the parent key to relate to Subjobs. Link to comment Share on other sites More sharing options...
Jalz Posted December 2, 2005 Author Share Posted December 2, 2005 Thanks Ender Thats sorted it. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6718 days old. Please don't post here. Open a new topic instead.
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 accountSign in
Already have an account? Sign in here.
Sign In Now