Jump to content

Portal showing unrelated records in related table?


MSPJ
 Share

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

Recommended Posts

Hi -

I'm trying to create a layout for assigning items to something like an invoice. No problem creating a portal to show items already assigned (ie related) to that invoice via the invoice ID.

But I'd like to have a second portal on the layout, showing items that have not yet been assigned to any invoice to pick from. I initially tried to figure out a way to show any item with nothing in the invoice ID field - but by definition those are unrelated records, so couldn't figure out how to show in a portal. I can create a separate layout and run a script that searches for records with that field blank - that works, but is not what I wanted.

There is also a boolean field (yes/no) for whether an invoice has been assigned (InvAssign). So I thought the second portal could use this. I created a global, gave it the value NO, and tried to use that global to relate to the InvAssign field of the table of items thinking that would work for the second portal - but it doesn't seem to work. Actually, it just shows the first such item, but no more.

Is this something that can be done? If so, why does this approach not work? Shouldn't the second portal show all items with No in InvAssign? I tried to do this two ways - using the same table occurrence as the first portal, and also by creating two separate TOs for the second portal - neither approach seems to work.

Thanks,

Michael

Link to comment
Share on other sites

Try the attached file....

I think this is what you are trying to do?

Its a very simple way of posting invoices to a unique ID. You will have to put conditions in the script to not allow more than the portal rows you have shown.

Ben

Invoice.zip

Link to comment
Share on other sites

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