Help make auto fill fields in a portal
Im trying to make a small invoice system. but i've ran into a little problem i hope someone can help me out.
I have a table called WIP where i "make" all the products through a portal into the table "product", which later is going to be used in invoices. I have in the portal two fields called Customer and Season. These fields is only there so it's possible to sort the products later in a later table. instead of typing in all the data for customer and season, is it possible to have two fields on the WIP table where you can type in the customer name and season and that will automatically spread out into all the records which is shown in the portal on that specific WIP record..?
attached is my realationship graph