Jump to content

splitting records


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

Recommended Posts

i have a materials list database that has

date, client, quan, description, vendor, unit price

Sometime, when we have a bill, i need to split the bill for different clients...what I do now is enter date and vendor and press copy a few times and enter client, quantity, description, price, etc.

However, I was wondering there is a way to enter date, vendor and then have a button to click if I need to split bill and a new window opens with client, quantity, description, etc. and I'm able to enter all the clients there...Then when I go back to the materials layout..it shows a separate record for each entry as above...

is this possible and if so, how?


Link to comment
Share on other sites

Define a text field, OrderSplit.

Define a Self-Relationship, Split, based on this field, and be sure to have it allow creation of related records.

Make a layout with a portal based on Split, and put the fields you need in it.

Now make a script:

Set Field (OrderSplit, OrderNumber & "Split")

Go to layout (Split Layout)

Go to field (Split::Client)

Now you're all set to enter new orders in the portal!

One more thing to do: for the fields that you want to auto-enter the same info as the first order, give them auto-enter calculations like this (sample to auto-enter Vendor)...

Case(IsEmpty(OrderSplit), "", Split::Vendor)

Link to comment
Share on other sites

This topic is 7392 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.