Hello Board,

I really like the idea of portals, or what i think they are, but i don't get it. I'm new to building db's.

I have a table that records a job process. There is a 'Job Number' and then the individual processes that occur are added as New Records with that Job Number being the same.

When someone enters a Job Number into the field, i'd like a Portal to show the other records that also have that same Job Number. I would also like to count how many records there are that are in that portal, matching that Job number.

Is that possible?

I'm not really getting how to use the Portal. i've tried building the above a few times but i can't seem to get the data to display. I can't seem to pick up the current Job Number field record as the one to do a search/filter on for the Portal to display.

Any help, greatly appreciated.

When someone enters a Job Number into the field, i'd like a Portal to show the other records that also have that same Job Number.

It seems like you should have a table of Jobs and a table of Processes, with a one-to-many relationship between them (i.e. based on matching JobID). If you place a portal to Processes on a layout of Jobs, each job record will show its own processes in the portal.

Hi there,

I didn't quite understand what you meant, but i've now played around with it and having read your other post, i got it to work. It's pretty simple, of course. I didn't think about copying the table like that.

Thank you for helping, i've been working on this for a few weeks now and it's coming together quite nicely.