Can a Related Database be split into 2 portals

[randy remark]

I have a database that stores rentable products

I want to show a diary split into items going out and items coming back.

Booking Ref Customer Date Out Time

Booking Ref Customer Date In Time

Hope this makes sense.

Thanks

[andygaunt]

Mark,

If you create a couple of calculation fields, possibly incorporating a global to allow you to switch the date and relate these to the in/out section you can definitely have two portals for your diary.

It is just a case of getting the keys to work together.

Let me know if I can be of help on this

[Fitch]

You can relate one database to another by more than one key field. So one portal can be related by Date In, and another by Date Out.