Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

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

Recommended Posts

Posted

Here's one for you.

I have a table "Orders" and another "OrdersPart"

When I create another OrderPart for my Order through a script

Freeze Window

Set Field[Orders::gOrderID;""]

Set Field[NewOrderPart::OrderID;Order::OrderID]

Commit Records/Request

It creates a new OrderPart that related to the Order Table just fine.

But then, in my layout, it contiues to edit the original OrderPart instead of the newly created one.

Should I add more to the script?

In my layout I have the Orders Table as the destination table(Or whatever you call it when you create the layout and it asks from which table) and the OrdersPart table and tables that are connected to the OrdersPart table in portals and on the layout itself.(example: "Colors","Size" tables) I have tryed and tryed different things but I think my understanding of how TO's and layouts work is holding me back.

Posted

When I tryed it with New Record/Request it would make a new "Order"... I just wanted to add an "OrderPart" to the "Order". Maybe I was using it in the wrong place???

Posted

I think I haven't understand you correctly !

While you are in Orders Table, You can add a new OrderPart directy (without a script) in the portal showing the orderParts related to Orders.

But You had to Allow creation of records via relationship while you was in "Edit Relashionship"

Posted

Yes, that seems easy enough and I thought that wsa what I am doing but....it's not working. I have looked at it so much that I am afraid it's something silly that I can not see. Maybe if you wouldn't mind taking a look see?:

Thank you

Printing_Company.zip

Posted

Hi Ginxy33

The problem regarding your first post is that you are setting a field in the New OrdersPart TO whereas on the layout you have a portal into the OrdersPart TO and although they have the same underlying table they are not the same in this context.

In your orders layout you simply have to type data into the portal rows (OrdersPart) to create new records in Orders Part. I do not understand your structure well enough to see other problems. One thing I am not clear about is the OrderPartID number. There does not appear to be any obvious way of choosing it. (The firstink etc are fine with drop-down lists). Another problem with this layout is that the Tab order seems a bit odd and is worth looking at.

This topic is 6944 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
×
×
  • Create New...

Important Information

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