Adding a customer specific record to customer subform
Hi,
Can anyone point me in the right direction I have customers as a form with all their details on it.
I also have separate jobs, tasks & assets forms that I can also fill out, now when I create one of these records let say for Customer A - I fill out an assets form, this records it in all assets which is fine as I need that info but I would also like that asset form to be showing in Customer A form under a subform (or other method if anyone has any suggestions)
so basically when i click on that customers details it will show jobs, assets, tasks all in subforms relating to them and only them but I can then still go to all jobs, all assets all tasks if that makes sense?
Also in there a limit to how many subforms the customers form can have?