Newbies jnolla Posted January 30, 2005 Newbies Share Posted January 30, 2005 I have a database I've created for customer relationship management; and now I'm trying to integrate another FMP DB for scheduling purposes. I file referenced them one to the other, and creted tables for each in the relatioships window, now what I'm trying to do is: 1. Open the Scheduling window > 2. Get the Customers info, for the new appointment, and place it in the customer field in the Scheduling program; manually enter the rest of the information > 3. After the new appointment has been submited, a portal row in the ,management program should display all the appointment related to that specific customer. I currently have this script running: [color:"red"]New Appoinment Commit Records/Requests [ No dialog ] Set Field [ DatesConstant::CompanyName; Company::Name ] Set Field [ DatesConstant::DateGlobal; Scheduling::CalDay ] Set Field [ DatesConstant::ProjectGlobal; Scheduling::varTab ] Perform Script [ "NewRec2" from file: "Dates 4" ] Select Window [ Name: "Dates" ] [color:"red"]NewRec2 Enter Browse Mode Go to Layout [ "FormMeasure" (Dates) ] New Record/Request Set Field [ Dates::Customer; Dates::CompanyName ] Set Field [ Dates::Date; Dates::DateGlobal ] Set Field [ Dates::Project; "Measure" ] Adjust Window [ Resize to Fit ] No luck so far can some one help? Link to comment Share on other sites More sharing options...
This topic is 6624 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
Already have an account? Sign in here.Sign In Now