I have two tables suppliers & purchasing each have their own layout, I have a portal on suppliers which lists all records relating in purchasing, works very nicely. But what I want to do is create a new layout with a portal on it that will list all records from purchasing not just records that are related to suppliers suppliers.

Any assistance with this would be greatly appreciated.

Many thanks

I always create a calculation field in every database I build which is simply a number calculation returning "1" (you need only type 1 in the calculation creation area). Lets call this field "one". In your case you would have this calculation field created in both your databases. Now simply create a relationship between these 2 fields and all records will show in your portal.

This field is also useful when you want to "Count" the number of records in the relationship. Instead of using the Count function I always calculate the number of related records with a calculation: Sum(related::one).

You can also make a relationship with Purchasing itself without defining a extra field.Suppose you have PurchageID as the primary key then make a relationship "PurchageID x PurhchageID" .It will show you all the records in the portal

bharti01 is quite right, but then you must view the portal in purchasing, not in suppliers.

With your help I have now sorted problem, thanks guys