As always scripting is my weakest point.... I would like to set up an easy way to import from excel some records to go into a portal. Let me explain this a bit better...
- Table A with various fields, and ID field
- Table B (part no, description, qty) ID field and link field to Table A ID field
- Layout 1 where all the info for Table A shows and via a Portal info of Table B is shown
The aim is that whenever the user is in a particular record on Table A he can import from an excel sheet various items into Table B for that particular record on Table A. This is going to be a recurring thing so I would like to put in a scripted button to make it easy on the user.