Jump to content

add/edit related files


George Swisher
 Share

This topic is 6561 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I have a database called Job Tickets and related database called Clients.

I want to see if there is a way I can view the files in Clients as a seperate layout in Job Tickets instead of having to open the Client database to add/edit new clients.

Kind of like the way ACCESS handle sub-reports in a main database. it allow you to create a main database, and add/edit sub tables inside the main database without having to open the sub table.

Link to comment
Share on other sites

Hi George

Make a relationship between the two files if you do not have one and on a separate layout in the db job ticket create a portal with that relationship and installed the fields from the client db that you want to see.To create a new record make sure you check the create new record box when you make the realtionship.

Lionel

Link to comment
Share on other sites

The problem is that there is no related files to create the relationship. I just want to be able to view the Client database in the Job Tickets database on a layout called clients. If I create a relationship, won't it only show the values associated to the relationship? I am not sure which field to create the relationship to show all the records in the CLients database?

Link to comment
Share on other sites

Hi George

You said:

"I have a database called Job Tickets and related database called Clients." If they are related then you must already have a relationship established. Use that relationship to make your portal. If not, How do you get the information from client to job tickets.lionel

Link to comment
Share on other sites

Sorry, let me back up...

They are related in that to create a Job Ticket, the user has to select a client from the drop-down menu that is a related value list from the client database.

When I added the portal from that relationship, it allows me to create the record but just is a little corkie when doing so.

Let me play with it some more and sure I will have some more questions.

thanks for the help.

Link to comment
Share on other sites

This topic is 6561 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

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